HP ProLiant DL980 G7 Server - Manual (Page 8)

•
Data Warehouse (DW) / Business Intelligence (BI) identification and support
User interface for entering login credentials for DW and BI instances ◦
◦ Recommendations for optimized settings for the following parameters in DW instances
and databases, based on monitored workload:
– Max Degree of Parallelism (MAXDOP)
– Max Worker Threads
– Startup options (trace flags) T834, T8048, T1117, and T1118
◦ Recommendations for optimized settings for the following parameters in SQL Server
Analysis Services (SSAS) instances, based on monitored workload:
– Resource Monitor
– RandomFileAccessMode
– FlightRecorder
– Enable ROLAP Distinct Count On DataSource
– Coordinator Query Balancing Factor
– CordinatorQueryBoostPriorityLevel
– MemoryLimit (Low/Total)
– Analysis Services Process GroupAffinity (only for SQL Server 2012 Analysis Services)
◦ Recommendations for optimized storage settings for the following parameters in DW
instances:
– Database file autogrowth (Growth)
– Storage layout of database files
◦ Recommendations for optimized storage settings for the following parameters in SSAS
instances:
– DataDir, LogDir, and TempDir
– Custom storage location of databases
– Partition information such as Proactive Caching, Estimated Rows, Estimated Size
•
SAP Database Engine identification and support
Recommendations for optimized settings for the following parameters in databases, based
on monitored workload: ◦
– Max Degree of Parallelism (MAXDOP)
– Checkpoint
– Xp_CmdShell
– Startup options (trace flags) T1117, T1118, T2371, T2549, and T2562
– Database auto create/update/async statistics
◦ Recommendations for optimized storage settings for the following parameters:
– Database file autogrowth (Growth)
– Storage layout of database files
•
Improved response times for page loading, saving, and rollback
8 Introduction