|
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.
Instructions:
- Install the latest version of RamDisk or RamDisk Plus.
- Stop SQL Server.
- Add a RAM disk to the system.
- Select a size large enough to contain the tempdb file.
- Select an appropriate drive letter.
- Select "NTFS" file system, without compression.
- Configure MS SQL Server to place the tempdb file on the RAM disk. If necessary, reduce the SQL Server's system memory allocation limit.
- Start SQL Server.
|
|
|
|
Copyright © 2001 - 2010 AMT Software. All rights reserved. All trademarks are property of their respective owners. Information subject to change without notice. Revised 18/3/2010 |
|