HP ProLiant DL980 G7 Server - Manual (Page 22)

SQL Server
The SQL Server page contains recommendations for setting SQL Server parameters.
Figure 22 SQL Server Page
Maximum Degree of Parallelism
When SQL Server runs on a system with more than one microprocessor or CPU, it detects the best
degree of parallelism. Specifically, it recognizes the number of processors employed to run a single
statement, for each parallel plan execution. Use the Max Degree of Parallelism option to limit the
number of processors to use in parallel plan execution.
Lightweight Pooling
Use the Lightweight Pooling option to reduce system overhead associated with the excessive context
switching sometimes seen in symmetric multiprocessing (SMP) environments. When excessive
context switching is present, lightweight pooling can provide better throughput by performing the
context switching inline, thus helping to reduce user/kernel ring transitions.
Priority Boost
Use the Priority Boost option to specify whether Microsoft SQL Server should run at a higher
Microsoft Windows 2000, Windows Server 2003, Windows Server 2008, or Windows Server
2008 R2 scheduling priority than other processes on the same system. If you set this option to 1,
SQL Server runs at a priority base of 13 in the Windows 2000, Windows Server 2003, Windows
Server 2008, or Windows Server 2008 R2 scheduler. The default is 0, which is a priority base
of 7.
Min Server Memory (in MB)
Use the Min Server Memory option to specify whether SQL Server should start with at least the
minimum amount of allocated memory and not release memory below this value. Set this value
based on the size and activity of your SQL Server instance. Always set the option to a reasonable
value to ensure the operating system does not request too much memory from SQL Server and
inhibit Windows performance.
22 Using HP ESO