The Latest Gartner® Magic Quadrant™Hyperconverged Infrastructure Software
Moderators: anton (staff), art (staff), Anatoly (staff), Max (staff)
GaryL wrote:We have a SAN with SQL Server Temp databases on RAID 10 drives. We are thinking of moving them to memory to get even better performance. Do you have any products like a RAMDISK that is supported on Windows Server 2008R2 and can create RAMDISKS of up to 32Gb in size?
If you are not affraid that your data will be 100% lost after power outage or similar situation than you can use RAM disk.GaryL wrote:Technically why would caching to SSD be faster than RAMDISK? Since TempDB is only temporary data it appears perfect for RAM with no need to store on Disk.
Our software works on WS2008R2, so feel free to use it. My colleague Bohdan provided you the link to download in the post above.GaryL wrote: Is 64bit RAMDISK supported on Windows Server 2008R2?. Is there a version that can be purchased or just the free version I see on the website that sales told me is unsupported.
GaryL wrote:Hi Anton,
Please elaborate:
1)Technically why would caching to SSD be faster than RAMDISK? Since TempDB is only temporary data it appears perfect for RAM with no need to store on Disk.
2)Is 64bit RAMDISK supported on Windows Server 2008R2?. Is there a version that can be purchased or just the free version I see on the website that sales told me is unsupported.
Thx.
where is the 64-bit edition?anton (staff) wrote:1) Bad idea. Use StarWind with caching and SSD back end.
2) Standard 64-bit edition of our RAM disk package supports unlimited capacity (OK, limited with size of your non-paged pool).
GaryL wrote:We have a SAN with SQL Server Temp databases on RAID 10 drives. We are thinking of moving them to memory to get even better performance. Do you have any products like a RAMDISK that is supported on Windows Server 2008R2 and can create RAMDISKS of up to 32Gb in size?
Anatoly (staff) wrote:Dear allfusion,
I would recommend you to use StaRWind Free. You can download it by using teh link below:
http://www.starwindsoftware.com/download-free-trial
After you will install it and connect to host you will be able to create RAM disk.
Also, could you please clarify one thing:
When you are tryinh to create the RAM disk, is there more then 112 Megs of RAM free? Maybe something else is using the memory?
Bohdan (staff) wrote:Did you check the Large drive (AWE mode) option?
In what way was the RAM disk connected to the computer? Locally (127.0.0.1) ?