![dataram ramdisk driver won dataram ramdisk driver won](https://static1.makeuseofimages.com/wordpress/wp-content/uploads/2021/07/windows-10-dataram-ram-disk.png)
Secondly, when loading TempDB into RAM, I'm assuming you set it up as fixed sized NDFs with additional HDD based ones for overflow? I'm guessing I'll need to monitor the HDD-based NDFs when benchmarking - or give both optimal and real-word results. Just to bump this thread up - i'm about to embark on a similar project for my company and i'm while I can see TempDB access operates similar to the 4KQD32 test on CrystalDiskMark - what kind of bandwidth should I be looking at? We runĀ 1866MHz RAM in our servers, which technically gives out a bandwidth 14.583GB/s - but as it will be formatted in NTFs, with the RAMDisk writes back to the HDD for backup, and i'm sure there are other factors - can you get above the 50-70% efficiency (>7 GB/s). What do you think folks? Would you try this, or would you rather go with a conventional, dedicated RAID10 array for SQL logs? I am very tempted :) Also, I can implement hourly transaction log backups. Heaving said that, it is not often to see RAM fail. Unlike TempDB, which gets recreated every time you start SQL service, it would be a pain to mitigate the loss of SQL database logs. The one thing that scares me is there is no redundancy to RAM. The RAM has gotten so cheap and abundant these days, why not include 4 additional 16GB sticks and put not only my TempDB, but SQL Logs into RAM drive as well? :) While scoping my spindles, a crazy idea came in mind. I am now shopping for a replacement server hardware for our heavily used ERP system & OLTP back-end SQL Server.
![dataram ramdisk driver won dataram ramdisk driver won](https://heelpbook.altervista.org/wp-content/uploads/2014/05/ImDisk-Virtual-Disk-Driver.jpg)
My TempDB latency has gone down from double-digits to 0-1. You don't need any apps running to make this work it's all handled with services.
![dataram ramdisk driver won dataram ramdisk driver won](https://heelpbook.altervista.org/wp-content/uploads/2014/05/systeminf-550x455.png)
Dataram ramdisk driver won't load software#
About 8 months ago I resolved a tempdb bottleneck by creating a TempDB drive in RAM, using RAMDisk software to accomplish this http:/ / / products-and-services/ software/ ramdisk. Maximize the RAMDisk Configuration window, select the LOAD and SAVE tab, and click SAVE DISK IMAGE NOW - this is the second part of what maintains a persistant image over reboots.