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