Ramdisk Plus Non-Cluster-Ramdisk

How to Implement the tempdb Solution on a Machine that Is Not Part of a Cluster

Preliminary considerations:

• Examine the size of the tempdb file and the amount of available free memory. If the tempdb file is 100 MB or less, a RAM disk is unlikely to improve performance. If the tempdb file is greater than available physical memory, add more RAM to the system.



• Consider the impact of reallocating system memory to the RAM disk. Sufficient memory resources must be available for SQL and other processes.



• On a production machine, determine a convenient time when SQL Server can be stopped. SQL must be stopped to change the tempdb path, and, possibly, to reduce its memory allocation limit.

1. Install the latest version of RamDisk or RamDisk Plus.



2. Stop SQL Server.



3. Add a RAM disk to the system.



1. Select a size large enough to contain the tempdb file.
2. Select an appropriate drive letter.
3. Select "NTFS" file system, without compression.



4. Configure MS SQL Server to place the tempdb file on the RAM disk. If necessary, reduce the SQL Server's system memory allocation limit.



5. Start SQL Server.