I was looking for ways to improve the performance of my SQL database and I came across RAMdisk. So I am thinking of hosting the database on the ramdisk. Obviously I need to make sure, that if the RAMdisk ever fails or if the computer crashes, that the database and contents do not get lost.
My idea was to use an image file for persistent RAMdisk and write every 5 minutes to the image file.
Does anyone have any experience and tips with this?
Will 5 minute cycle be OK or will it put too much stress on ramdisk?
Any known issues with ramdisk and SQL database?