Hp ProLiant DL980 G7 Server User Manual download pdf (Page 52)

master Auto check box. In Figure 42 (page 51), the master Auto check box for instance SQL2012_Bl

is circled in green. As described in more detail in “Modifying and setting Database Engine Processor

Affinity” (page 53), when you check the master Auto box, you are setting up all the instance’s

CPUs for automatically affinity — you must click SET to make this setting take effect. When you

clear this box, you can enable manual affinity for selected CPUs in the list.

A check mark “✓” in the Current column’s Auto value box at the top of a CPU list indicates that

automatic (dynamic) affinity is in effect for that list. A check mark in the Recommended column’s

Auto value box at the top of the CPU list indicates that HP ESO recommends automatic (dynamic)

affinity for the CPUs in the list. A check mark in the New Value column’s master Auto check box

indicates that the recommended automatic affinity will be in effect for the entire instance after you

click SET. When the Auto check box for the Current or Recommended column is blank, manual

affinity is in effect or recommended (depending on the box) for one or more CPUs in the list.

If the NUMA architecture is supported, boxes to the right of each NUMA id (NUMA 0, NUMA 1,

and so forth) reflect or control the manual affinity setting for a specific NUMA CPU list. When a

NUMA New Value master check box is checked (in Figure 42 (page 51), this master check box

is circled in purple), the SQL Server will manually affinitize all CPUs under that NUMA after you

click SET. When cleared, HP ESO enables automatic affinitization for the NUMA CPUs after you

click SET. If the master Auto box at the top of the instance’s New Value column is checked, then

the CPU page displays a dash (“—”) for each NUMA and CPU in the New Value column, as

shown in Figure 43 (page 52). This means manual affinity will be disabled when you click SET;

automatic affinity will take effect for all CPUs in NUMA 0 and all other NUMAs for that instance.

Figure 43 Automatic affinitization setting for all instance and NUMA CPUs

Under each Database Engine instance, or within each NUMA CPU list for a Database Engine

instance, the CPU page displays the current, recommended, and new value for each individual

CPU’s affinity/allocation state. By default, the new value is the same as the recommended value.

A dash (“—”) as a specific CPU’s Current value indicates that the CPU is automatically affinitized.

A check mark indicates that the CPU is manually affinitized.

If the check box in the New Value column to the right of a specific CPU is cleared (as are the boxes

circled in red in Figure 42 (page 51)), the check box is enabled so that you can check the box to

52 Using HP ESO

1 2 ... 47 48 49 50 51 52 53 54 55 56 57 ... 80 81

No comments

Hp ProLiant DL980 G7 Server User Manual Page 52