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

NOTE: Do not set Database Processor Affinity and IO Affinity to the same CPUs. This can degrade

system performance (HP ESO displays a warning if the system is configured this way). As a general

rule, HP ESO recommends manual affinity for only a few specific processors in SQL instances that

are comparatively lightly utilized. This helps ensure that a substantial number of system processors

is available for handling heavier workloads. Likewise, HP ESO does not recommend manual affinity

for heavily utilized SQL instances — they need to use all available system processors.

From a single GUI interface, Processor Affinity can be set for the SQL Database Engine and Process

GroupAffinity for Analysis Services. This reduces the complexity of setting instance affinity

one-by-one. In addition to the CPU/NUMA information shown in the SQL Server Management

Studio GUI, HP ESO also shows the Processor Group information. This helps the user allocate

resources properly, based on application needs (some applications might not be using all Processor

Group information).

Analysis Services Process GroupAffinity

To support multiple processor groups and thus more than 64 CPUs, SSAS 2012 was updated to

set the process affinity mask for the msmdsrv.exe process to span multiple processor groups.

Along with this capability, a new configuration property named GroupAffinity was added for each

thread pool in the server. This property allows an SSAS administrator to have fine-grain control

over which CPUs on a machine are used for each thread pool managed by Analysis Services. The

GroupAffinity setting is a bitmask that determines which CPUs in a processor group can be used

for the thread pool in which the GroupAffinity mask is defined. This setting is supported with SQL

Server 2012 Analysis Services only.

Figure 46 (page 57) shows two Analysis Services instances with the NUMA 1 CPU lists expanded

for view. Modify the Process GroupAffinity in a similar fashion as that described for the Database

Engine Processor Affinity parameter in “Database Engine Processor Affinity” (page 51).

NOTE: When you click SET to apply changes, HP ESO displays a message that the instance

should be restarted for the changes to take effect. SQL instances that need to be restarted have

this symbol alongside their names after refreshing the page: .

Figure 46 Analysis Services Process GroupAffinity view

Optimizations pages: Viewing and controlling optimization recommendations 57

1 2 ... 52 53 54 55 56 57 58 59 60 61 62 ... 81 82

No comments

Hp ProLiant DL980 G7 Server User Manual Page 57