HP ProLiant DL980 G7 Server - Manual (Page 51)

Viewing and understanding Database Engine Processor Affinity
To view current and recommended Database Engine Processor Affinity settings, expand the Database
Engine instance CPU list (if necessary) that you want to view or modify. For example, in
Figure 41
(page 51) , to display the CPU list for NUMA 0, click the expand button shown circled in red.
Figure 41 Expand the CPU list
Figure 42 (page 51) shows an example of an expanded NUMA CPU list for an SQL 2012 Database
Engine instance.
Figure 42 Expanded CPU list
At the top of an instance section, the Auto boxes for the Current, Recommended, and New Value
columns reflect or control the affinity setting for all the instance’s CPUs. The only box you can check
at the top of an instance section is the New Value column’s Auto check box, referred to as the
Optimizations pages: Viewing and controlling optimization recommendations 51