Tuning SQL Server 2005 on Windows Integrity Servers

Page 12 of 13
change show advanced options to 1. The setting takes effect immediately without a SQL instance stop
and restart.
If an application uses TempDB, put TempDB on fast disks (write cache enabled) that are large enough
to support the data traffic (i.e., avoid auto-grow). Spreading TempDB to multiple files also helps
improve performance. A general rule is one TempDB file per CPU.
Conclusion
HP Integrity servers provide powerful computing and memory resources. To enable your SQL Server to
take full advantage of these resources, we recommend hardware and software tuning. By applying
some or all of the guidelines in this document, you will realize the greater benefit from your server.