HP ProLiant DL980 G7 Server - Manual (Page 54)

manually affinitize that CPU. If a CPU’s New Value check box is checked, it will be manually
affinitized after you click SET.
Modifying and setting Database Engine Processor Affinity
Overview
To enable automatic affinity for an instance’s CPUs, or to disable manual affinity for one or more
CPUs, use the New Value column’s master Auto check box. This check box is circled in red in
Figure 44 (page 54) . To enable manual affinity for one or more CPUs, use the NUMA or individual
CPU check boxes circled in green in Figure 44 (page 54) .
NOTE: If the Recommended column’s Auto check box is blank, HP ESO is recommending manual
affinity for one or more CPUs in the instance CPU list. Expand the CPU list to ascertain which CPUs
are recommended for manual affinity. Expand the CPU list by clicking the
expand buttons on
the left side of the instance column. For SQL 2008 instances, only one expand button exists per
instance. For later versions of SQL, expand buttons are available for each NUMA CPU list.
To apply settings, click SET (at the top of the instance column). The remainder of this section provides
more specific details about modifying affinity modes.
Figure 44 Automatic versus manual affinitization setting boxes
Details about modifying and setting Database Engine Processor Affinity
To modify and enable Database Engine Processor Affinity for one or more CPUs, follow these
steps:
54 Using HP ESO