We're currently virtualizing our database server and the idea is to use a ramdisk to help optimizing its performance. What we have is an instance of MS SQL 2008R2 Enterprise edition, hosted on a 2008R2 server, virtualized into the VMware ESXi environment.
We are looking for suggestions as to what solutions are available and most suitable for our set-up. I have been give the following advice, but no tips for an actual product:
Firstly the software should be an industry level app, no desktop stuff. In practice what you looking for must be designed to run on a server
Secondly, it should be able to control the properties/settings of the actual disk and the way it transfers the data further.
It is also about the size of the database. In reality you should make it happen so that the database is loaded into the RAMdisk during the server startup. You run it from the RAMdisk and only synchronize it every let’s say 60 seconds with the physical drive (in the background). Logs should in this case be on the physical drive and the database should be in the “full recovery mode”. So even if something breaks, then after reboot the database will repair itself in accordance with the saved log, to the point of the last transaction.
We would really appreciate your help on this.