Ramdisk for SQL Server indexex
Posted: Sun Sep 23, 2018 7:50 pm
I'm testing this on my PC before I move it to my client's server. The TempDb file is on a ramdisk, and is working perfectly -- but it's recreated each time the system is rebooted. The indexes are more complex as they must be saved through reboots; also, the ramdisk must increase in size when the index file grows. I tried it first with a File-Disk, it was saved through reboots but it couldn't grow when needed. Then I tried it with a Hybrid-disk, it wasn't saved through reboots. Neither of the disk types allowed me to manually or periodically save the file in the ramdisk as the Image Settings button is greyed out. I tried to attach a vdd file for the Hybrid-disk, but your forum wouldn't allow me to attach it. Can you point me to an approach that will work for me? TIA, Fred.