HP ProLiant DL980 G7 Server - Manual (Page 6)

1 Introduction
HP Enterprise SQL Optimizer (HP ESO) is a software tool that greatly simplifies and consolidates
the process of tuning HP ProLiant DL980 G7 servers running Microsoft Windows Server and SQL
Server 2008, SQL Server 2008 R2, or SQL Server 2012. Use HP ESO to:
•
Reduce the time and complexity of configuring and tuning systems running SQL Server
•
Reduce the number of support calls due to misconfigured systems
•
Help users optimize their configuration to ensure top SQL Server performance
•
Improve customer satisfaction
HP ESO achieves these goals by providing optimization tools for the following system components:
•
the Server – with hardware-related recommendations such as placement of PCI cards and
proper storage drive configurations, and information on the update status of HP software,
drivers, and firmware
•
the Operating System – with settings for Power Management Options and storage volumes
•
Microsoft SQL Server – with settings such as priority boost, light-weight pooling, CPU affinity,
and more
Features
HP ESO provides the following functionality for configuring and tuning your server and Microsoft
SQL Server:
•
Scheduled or Manual Data Collection, for use as reference when optimizing the system and
SQL Server
•
Built in knowledge of the hardware architecture, to properly optimize the server
•
Reports page that provides a graphical display of data collection parameters, for use in
analysis and interpretation, with the ability to export to a file
•
Built-in WBEM-based instrumentation for quick integration with other management tools such
as HP System Insight Manager
•
Capability to roll back to previously saved configurations. Use this feature to save the current
configuration, then retrieve and apply it in the future if necessary
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 28) .
•
New SQL Server Login page which allows users to specify login credentials used to optimize
each SQL server instance, see
“SQL Server Login” (page 16) .
•
Session-based usage model to prevent simultaneous access and control of the tool, see “Quick
Start Guide” (page 14) .
•
Support SQL Server Startup options (Trace Flags) settings, see “SQL Startup Option” (page 20) .
•
Network RSS (Receive Side Scaling) settings recommendations, see “Receive-Side Scaling”
(page 29) .
•
New information on HADR (High Availability Disaster Recovery) configured databases and
SQL servers, see
“High Availability and Disaster Recovery” (page 24) .
6 Introduction