HP ProLiant DL980 User Manual
HP Enterprise SQL Optimizer (HP ESO) 1.0
User Guide
HP Part Number: AM426-9013A
Published: April 2012
Edition: 2.1
© Copyright 2011–2012 Hewlett-Packard Development Company, L.P.
Legal Notices
Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial
Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under
vendor's standard commercial license.
The information contained herein is subject to change without notice. The only warranties for HP products and services are set forth in the express
warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP shall
not be liable for technical or editorial errors or omissions contained herein.
Microsoft, SQL Server, and Windows are U.S. registered trademarks of Microsoft Corporation.
Intel and Xeon are trademarks of Intel Corporation in the U.S. and other countries.
Contents
About This Document.....................................................................................5
Publishing History.....................................................................................................................5
Organization...........................................................................................................................5
1 Introduction...............................................................................................6
Features..................................................................................................................................6
2 Installing HP ESO.......................................................................................7
Software Requirements..............................................................................................................7
Microsoft SQL Server Security Settings.........................................................................................7
Installing the Software...............................................................................................................7
Uninstalling the Software...........................................................................................................9
3 Using HP ESO..........................................................................................10
Starting System Management Homepage..................................................................................10
Getting Started Pages.............................................................................................................12
Introduction Page...............................................................................................................12
Settings Pages........................................................................................................................13
Configuration....................................................................................................................13
Data Collection.............................................................................................................13
Software Discovery........................................................................................................15
Optimizations Pages...............................................................................................................15
SQL Server........................................................................................................................16
Maximum Degree of Parallelism......................................................................................16
Lightweight Pooling........................................................................................................17
Priority Boost................................................................................................................17
Min Server Memory (in MB)...........................................................................................17
Maximum Server Memory (in MB)...................................................................................17
Check Point..................................................................................................................17
Database..........................................................................................................................17
File Growth..................................................................................................................18
Database File on System Drive........................................................................................18
Multiple Database File on a Drive....................................................................................18
CPU.................................................................................................................................18
SQL Server Affinity........................................................................................................19
IO Affinity....................................................................................................................19
Storage............................................................................................................................19
Database RAID Level.....................................................................................................20
Drive Free Space...........................................................................................................20
Network...........................................................................................................................20
NUMA Node Affinity....................................................................................................21
Interrupt Affinity............................................................................................................21
Port Affinity..................................................................................................................21
System..............................................................................................................................21
Power Plan...................................................................................................................22
System Update Advisory Information................................................................................22
PCI Controller Information..............................................................................................22
Reports Pages........................................................................................................................22
Workload and Performance History......................................................................................22
Save/Rollback SQL Configuration........................................................................................23
Help Pages............................................................................................................................24
Online Help......................................................................................................................24
Contents 3
4 Support and Other Resources.....................................................................26
Contacting HP .......................................................................................................................26
Before You Contact HP.......................................................................................................26
HP Contact Information.......................................................................................................26
Subscription Service...........................................................................................................26
Documentation Feedback....................................................................................................26
New and Changed Information in This Edition............................................................................27
Typographic Conventions.........................................................................................................27
4 Contents
About This Document
This document describes how to install and use HP's Enterprise SQL Optimizer (HP ESO) software.
HP ESO was created for system administrators and HP support personnel responsible for installing,
configuring, and managing HP ProLiant servers running Microsoft SQL Server. This document is
not a tutorial. For the latest version, see the HP Technical Documentation website:
http://www.hp.com/go/proliant_servers-docs
Publishing History
Manufacturing Part Number
AM426-9013A
Organization
This document is organized as follows:
Publication DateSupported Products (Servers)Supported Operating
Systems
November 2011HP ProLiant DL980 G7Microsoft Windows Server
2008 R2 x64 Edition with
Service Pack 1 (SP1)
Microsoft Windows Server
2008 with Service Pack 2
(SP2)
April 2012Same as above.Same as above.AM426-9013A
Describes HP ESO features and prerequisite software.“Introduction” (page 6)
Describes how to install HP ESO.“Installing HP ESO” (page 7)
Describes how to use HP ESO.“Using HP ESO” (page 10)
Publishing History 5
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
6 Introduction
2 Installing HP ESO
Software Requirements
The following prerequisite software is required in order for HP ESO to function properly:
• HP System Management Homepage (HP SMH), Version 6.0 or later
• Any Internet browser supported by HP SMH (refer to your HP SMH documentation for more
information)
• Microsoft .NET Framework, Version 2.0.50727 or later
• Microsoft SQL Server 2008 Management Objects (or Microsoft SQL Server 2008 R2
Management Objects; or Microsoft SQL Server 2012 Management Objects)
• HP Insight Management WBEM Providers (highly recommended)
Microsoft SQL Server Security Settings
The following steps are required for HP Enterprise SQL Optimizer to be able to access all SQL
Server instances in the system:
1. Open the Microsoft SQL Server Management Studio.
2. Login to each SQL Server instance using an account that is able to set permissions of other
accounts.
3. Choose the following selections: Security → Logins → NT_AUTHORITY\SYSTEM → right click
and select Properties → Server Role → Select public, serveradmin and/or sysadmin roles.
4. Repeat the above steps for all SQL instances for ESO to optimize the resources across all SQL
instances as per their work load.
Figure 1 SQL Server Management Studio Window
Installing the Software
To install HP Enterprise SQL Optimizer, follow these steps:
1. Login as Administrator on the target system.
2. Obtain the HP ESO installation file (filename: cpnnnnnn.exe) and either double-click on it, or
right-click and select Open.
3. The first installation window displays. Click Install to continue.
Software Requirements 7
Figure 2 Package Setup Window
4. The second installation window displays. Click Install to continue. The installation begins, with
a progress bar indicating status.
Figure 3 Setup Window #1
5. When the installation finishes successfully, click Close to exit.
Figure 4 Setup Window #2
NOTE: The HP ESO application files are installed into the %ProgramFiles%\McPerfOpt
folder, where %ProgramFiles% is typically: C:\Program Files.
8 Installing HP ESO
If the prerequisite HP Insight Management WBEM Provider software is not installed on the system,
you will see the following warning message during HP ESO installation:
Figure 5 Install Warning Window
Uninstalling the Software
To uninstall HP Enterprise SQL Optimizer, follow these steps:
1. Login as Administrator on the target system.
2. Navigate to the Add/Remove panel (or Programs and Features in the Control Panel).
3. Locate “HP Enterprise SQL Optimizer for Windows Server x64 Edition” in the resulting list of
programs. Right-click on it and click the Uninstall button.
4. A confirmation popup displays, asking you to confirm this action. Click Yes to continue.
5. A notification popup displays, confirming that HP ESO was removed. Click OK to close this
popup and complete the process.
Uninstalling the Software 9
Loading...