HP ProLiant DL980 G7 Server - Manual (Page 4)

Analysis Services properties............................................................................................36
Data Dir..................................................................................................................36
Temp Dir.................................................................................................................36
Log Dir....................................................................................................................36
Backup Dir..............................................................................................................36
Measure Group........................................................................................................37
Partition..................................................................................................................37
Estimated Rows........................................................................................................37
Estimated Size..........................................................................................................37
Proactive Caching....................................................................................................37
ESO database recommendation statements.......................................................................37
Database File on System Drive...................................................................................37
Multiple Database File on a Drive...............................................................................37
Database page: Viewing high availability and disaster recovery configurations.........................37
Availability Group.........................................................................................................37
Mirrored database........................................................................................................38
Clustered SQL Server instance.........................................................................................40
Cluster Network Name.............................................................................................40
Computer Name......................................................................................................40
Status.....................................................................................................................40
Computer Role.........................................................................................................40
CPU page: Viewing and enabling CPU assignment optimization recommendations.....................41
SQL Server affinity........................................................................................................41
Analysis Services Process GroupAffinity............................................................................42
Storage page: Viewing and enabling storage optimization recommendations............................42
Database RAID level......................................................................................................42
User Write Cache Setting...............................................................................................43
User Cache Power Protection..........................................................................................43
Drive free space............................................................................................................43
Volume mount point.......................................................................................................43
Network page: Viewing and enabling network optimization recommendations..........................43
NUMA node affinity......................................................................................................43
Interrupt affinity.............................................................................................................44
Port affinity...................................................................................................................44
Receive-Side Scaling......................................................................................................44
SQL Startup Option page: Viewing and enabling startup options.............................................45
Trace flag 8048............................................................................................................46
Trace flag 834..............................................................................................................46
Trace flag 1117..............................................................................................................46
Trace flag 1118..............................................................................................................46
Trace flag 2371............................................................................................................46
Trace flag 2549............................................................................................................46
Trace flag 2562............................................................................................................47
System page: Viewing and enabling system optimization recommendations...............................47
PCI Controller Information..............................................................................................47
Software Discovery .......................................................................................................48
System software and firmware status................................................................................48
Configuring and initiating Software Discovery............................................................................48
Reports pages........................................................................................................................49
Workload and Performance History......................................................................................49
Save/Rollback SQL Configuration........................................................................................51
Help pages............................................................................................................................54
Online help.......................................................................................................................54
4 Contents