– 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
Kommentare zu diesen Handbüchern