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

NOTE: Do not set SQL Server Affinity and IO Affinity to the same CPUs because it can degrade

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

rule, HP ESO recommends affinity on only a few specific processors for SQL instances that are

comparatively lightly utilized, so they do not use all of the available system processors. Likewise,

HP ESO does not recommend CPU Affinity for heavily utilized SQL instances, so they can use all

of the available system processors.

From a single GUI interface, processor affinity can be set for both SQL Database Engine and

Analysis Services Engine, for all the instances in the server. This reduces the complexity of setting

instance affinity one-by-one. In addition to the CPU/NUMA information shown in the SSMS 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.

Storage page: Viewing and enabling storage optimization recommendations

The Storage page displays recommendations for different storage parameters. Figure 37 (page 42)

shows an example of a Storage page.

Figure 37 Storage page

The following subsections describe the parameters affecting storage optimization.

Database RAID level

HP highly recommends that tempdb files and log files for user databases be on physical disks with

RAID 1 + 0 or RAID 1.

42 Using HP ESO

1 2 ... 37 38 39 40 41 42 43 44 45 46 47 ... 56 57

Keine Kommentare

Hp ProLiant DL980 G7 Server Bedienungsanleitung Seite 42