HP ProLiant DL980 G7 Server - Manual (Page 54)

1. If you want automatic affinity for all of the instance’s CPUs, check the New Value column’s
master Auto check box and click SET.
Figure 45 (page 54) shows the master Auto check box
circled in green. (If that box is already checked, all instance CPUs are set to automatic affinity
after you click SET.)
If HP ESO does not have recommendations for manual affinity, the New Value column’s master
Auto check box has a check mark. If an instance’s CPU utilization is too high, HP ESO
automatically inserts a check mark within the Auto check boxes for the Recommended and
New Value columns, indicating that the OS should continue automatically affinitizing all
CPUs.
If HP ESO has recommendations for manually affinitizing individual CPUs, the CPU page
displays a check mark in the Recommended column to the right of each recommended CPU
(expand and scroll down, looking particularly at the bottom of the CPU list or NUMA list for
the recommended CPUs). To comply with the recommendations, check the CPU’s New Value
box and click SET.
If you want to manually affinitize individual CPUs against HP ESO recommendations, clear
the New Value column’s master Auto check box. This clears and enables all check boxes (for
all CPUs) in the New Value column, allowing you to select individual CPUs for manual affinity
mode. To specify a new affinity setting, proceed with one of the following actions, as
appropriate:
•
To manually affinitize one or more specific CPUs, check the New Value column’s check
box to the right of each CPU, such as one of the boxes circled in red in
Figure 45
(page 54) (two CPUs are shown selected).
•
To manually affinitize all the CPUs in a specific NUMA list (NUMA 0, NUMA 1, or so
forth), check the master New Value box to the right of the NUMA id (in
Figure 45
(page 54) , the master New Value box for NUMA 0 is circled in purple). In versions of
SQL that do not support NUMA (such as SQL 2008), this choice is not available; you
must check all the CPU New Value boxes under the NUMA , one by one (in
Figure 45
(page 54) , the New Value boxes under NUMA 0 are circled in red).
•
To manually affinitize all the CPUs for an instance, check all master NUMA New Value
boxes. In versions of SQL that do not support NUMA, this choice is not available; you
must check all CPU New Value boxes one by one.
Figure 45 Setting automatic and manual affinitization
54 Using HP ESO