Best Practices for Tuning Microsoft SQL Server on the HP ProLiant DL980

Technical white paper | Best Practices for Tuning Microsoft SQL Server on the HP ProLiant DL980
19
Additionally, if an application uses the TempDB database, you should put TempDB on fast disks with write cache enabled.
These disks must be large enough to support the traffic (for example, avoid the AUTOGROW option). Spreading TempDB to
multiple files also helps improve performance. A general rule to follow is one TempDB file per CPU.
Conclusion
To reiterate, just as Windows Server 2008 can only support 64 logical processors, SQL Server 2008 has the same limitation.
For this reason you should only run SQL Server 2008 on the HP DL980 when Hyper-threading is disabled or if the
configuration has less than 64 logical processors. To best utilize the full computing power of the DL980, you should always
run Windows Server 2008 R2 or Windows Server 2012 with SQL Server 2008 R2 or SQL Server 2012 now as the Database
Management System (DBMS).
HP ProLiant DL980 Servers provide powerful computing and memory resources. To enable SQL Server to take full
advantage of these resources, HP recommends hardware and software tuning. By applying some or all of the guidelines in
this document, you will achieve the highest performance from your server.