HP ProLiant DL980 G7 Server - Manual (Page 8)

– 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 (autogrow)
– Storage layout of database files
•
Improved response times for page loading, saving, and rollback
•
Improved graphical user interface (GUI) on all pages, with most significant changes on:
CPU page — CPU affinity settings of all SQL instances are shown side by side for
convenience of comparison and analysis ◦
◦ SQL Startup Option page — Current status and additional details about trace flags in
one single page
•
Enhanced error handling, including additional detailed error messages presented in GUI and
log file
New features in release 2.0 and 2.1
HP ESO 2.0 additionally provides:
•
Windows 2008 R2 Server core support
•
SQL Server 2012 support
•
Volume Mount Point support (see “Volume mount point” (page 43) )
•
New SQL Server Login page that allows users to specify login credentials for SQL Server
instances (see
“SQL Server Login: Setting credentials and logging into SQL Server and Analysis
Services instances” (page 25) )
•
Session-based usage model to prevent simultaneous access and control of the tool (see “Quick
start: basic session” (page 21) )
•
Support for SQL Server startup options (trace flags) settings (see “SQL Startup Option page:
Viewing and enabling startup options” (page 45) )
•
Network RSS (Receive Side Scaling) settings recommendations (see “Receive-Side Scaling”
(page 44) )
•
New information on HADR (High Availability Disaster Recovery) configured databases and
SQL servers (see
“Database page: Viewing high availability and disaster recovery
configurations” (page 37) )
HP ESO 2.1 additionally provides a fix for more efficient CPU and memory resources usage.
Previous resources usage caused SQL Server, Database, CPU, and Network optimization pages
to hang for certain storage settings.
8 Introduction