sql server tempDB files on RAMDisk AND physical disk

442 Views Asked by At

We find, for our application, locating TempDB files on RAMDisk improves performance significantly. But we don't want to allocate more RAM to RAMDisk than necessary. Nor do we want SQL Server to fail because it can't grow TempDB. I remember reading that you could put one TempDB file (one data, one log) on physical disk, and permit them to grow, and have the rest (several data, 1 log) on RAMDisk, and do not permit them to grow.

But ... is there any way to stop SQL Server from using those slow TempDB files until the other fast files are full?

Thank you in advance

0

There are 0 best solutions below