Hp ProLiant DL980 G7 Server Bedienungsanleitung PDF herunterladen (Seite 53)

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 53). To enable manual affinity for one or more CPUs, use the NUMA or individual

CPU check boxes circled in green in Figure 44 (page 53).

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:

Optimizations pages: Viewing and controlling optimization recommendations 53

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

Keine Kommentare

Hp ProLiant DL980 G7 Server Bedienungsanleitung Seite 53