Hp ProLiant DL980 G7 Server Instrukcja Użytkownika Pobierz pdf (Strona 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

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

Brak uwag

Hp ProLiant DL980 G7 Server Instrukcja Użytkownika Strona 51