HP ProLiant DL980 G7 Server - Manual (Page 4)

Random File Access..................................................................................................40
Low Memory Limit.....................................................................................................41
Total Memory Limit...................................................................................................41
Coordinator Query Balancing Factor and Coordinator Query Boost Priority Level..............41
Enable Rolap Distinct Count On DataSource................................................................41
Process Min Threads.................................................................................................41
Vertipaq Memory Limit..............................................................................................41
Resource Monitor.....................................................................................................41
Server modes (Multidimensional Mode, Tabular Mode, Sharepoint Mode).......................42
Database page: Viewing and controlling database parameters and optimization
recommendations..............................................................................................................43
SQL Server Database Engine properties...........................................................................44
Growth...................................................................................................................44
Auto Create Statistics................................................................................................44
Auto Update Statistics...............................................................................................44
Auto Update Statistics Async......................................................................................45
Analysis Services properties............................................................................................45
Tabular Compatibility Level Number...........................................................................45
Data Dir..................................................................................................................45
Temp Dir.................................................................................................................45
Log Dir....................................................................................................................45
Measure Group........................................................................................................45
Partition..................................................................................................................45
Estimated Rows........................................................................................................45
Estimated Size..........................................................................................................46
Proactive Caching....................................................................................................46
ESO database recommendation statements.......................................................................46
Database File on OS Drive........................................................................................46
Multiple Files...........................................................................................................46
Create Column Store Index .......................................................................................46
tempdb Data File......................................................................................................46
Split the Partition......................................................................................................46
Enable Proactive Caching..........................................................................................46
Viewing high availability and disaster recovery configurations............................................46
Availability Group....................................................................................................46
Mirrored database...................................................................................................47
Clustered SQL Server instance....................................................................................49
CPU page: Viewing and controlling CPU assignment parameters and optimization
recommendations..............................................................................................................50
Database Engine Processor Affinity..................................................................................51
Viewing and understanding Database Engine Processor Affinity.....................................52
Modifying and setting Database Engine Processor Affinity.............................................54
Analysis Services Process GroupAffinity............................................................................57
SQL Startup Option page: Viewing and controlling SQL Server startup options..........................58
Trace flag 8048............................................................................................................58
Trace flag 834..............................................................................................................58
Trace flag 1117..............................................................................................................59
Trace flag 1118..............................................................................................................59
Trace flag 2371............................................................................................................59
Trace flag 2549............................................................................................................59
Trace flag 2562............................................................................................................59
Storage page: Viewing and controlling storage parameters and optimization recommendations....60
Database RAID level......................................................................................................60
User Write Cache Setting...............................................................................................60
Cache Power Protection..................................................................................................60
4 Contents