Show all posts by user

Re: Using RAM Disk for SQL Server tempDB: possible issues

6 years ago, by Gary_D in RAM Disk Forum

Thanks for your reply, Andrew. I think the 4K DiskMark test better reflects SQL reads/writes than sequential. Records are stored all over the place and are rarely sequential unless you're selecting them in the identical order they were written - assuming they were written sequentially to begin with. Even with HDD emulation the RAM disk is still several times faster than an SSD drive. In fact it's

Using RAM Disk for SQL Server tempDB: possible issues

6 years ago, by Gary_D in RAM Disk Forum

I've been using 12GB RamDisk installed on a Hyper-V VM (90GB RAM) for use as the tempDb for SQL Server. In tests it's done a great job in speeding up large queries. However, in recent more intensive tests we've noticed queries taking a very long time that we end up aborting. We're trying to discover where the issue is - it could be anything. The RamDisk option to emulate a hard disk is disabled

Re: What are you using RamDisk for?

6 years ago, by Gary_D in RAM Disk Forum

Using RamDisk as the tempDb for Microsoft SQL Server. Given that it's 5 to 10 times faster than an SSD in DiskMark tests, and the tempDb is disposable between reboots, it makes perfect sense.