HP ProLiant DL980 G7 Server - Manual (Page 7)

New features in release 3.0
HP ESO 3.0 provides the following new features:
•
Windows 2012 support
•
Windows 2012 Server Core support
•
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:
– Maximum Degree of Parallelism (MAXDOP)
– MaxWorkerThreads
– 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:
– ResourceMonitoringEnabled
– RandomFileAccessMode
– FlightRecorder
– EnableROLAPDistinctCountOnDataSource
– CoordinatorQueryBalancingFactor
– 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 (autogrow)
– 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: ◦
– Maximum Degree of Parallelism (MAXDOP)
– Checkpoint
– Xp_CmdShell
New features in release 3.0 7