
Contents
1 Introduction...............................................................................................6
Benefits of using HP ESO...........................................................................................................6
Main features of HP ESO...........................................................................................................6
New features in release 3.5.......................................................................................................7
New features in release 3.0.......................................................................................................7
New features in release 2.0 and 2.1...........................................................................................9
2 Installing HP ESO.....................................................................................10
Software requirements.............................................................................................................10
Installing the software..............................................................................................................10
Uninstalling the software..........................................................................................................12
Upgrading the software...........................................................................................................12
Silent installation....................................................................................................................13
3 Configuring user accounts to enable access to SQL Server and Analysis Services
instances....................................................................................................14
Set user account privileges in Database Engine security...............................................................14
Set user account privileges in Analysis Services security...............................................................15
4 Using HP ESO..........................................................................................18
Getting started.......................................................................................................................19
Launching HP ESO.............................................................................................................19
Getting Started pages........................................................................................................22
HP ESO Introduction page..............................................................................................22
HP ESO SQL Login page................................................................................................23
Quick start: Tasks performed in a typical HP ESO user session.................................................24
Floating help for items on a page........................................................................................27
Starting an authenticated Administrator Session (Admin Session)..............................................28
SQL Login page: Setting credentials and logging in to SQL Server and Analysis Services
instances..........................................................................................................................29
Modifying the Admin Session timeout value...........................................................................30
Settings pages: Setting parameters for data collection.................................................................31
Data Collection page: Collecting data for analysis and optimization recommendations...............31
Optimizations pages: Viewing and controlling optimization recommendations ...............................33
Summary page: Viewing recommended optimization values for settable parameters obtained from
all optimization pages; generating a PowerShell script for setting these recommended values.......34
Modifying how the Summary page displays and generates recommended values..................36
Downloading the PowerShell script..................................................................................36
SQL Server page: Viewing and controlling SQL Server and Analysis Services parameters and
optimization recommendations............................................................................................37
SQL Server database instance parameters........................................................................38
Max Degree of Parallelism.........................................................................................38
Lightweight Pooling...................................................................................................38
Priority Boost............................................................................................................38
Min Server Memory (in MB).......................................................................................38
Max Server Memory (in MB)......................................................................................38
Recovery Interval......................................................................................................38
Lock Page................................................................................................................38
Max Worker Threads................................................................................................39
Xp_CmdShell...........................................................................................................39
Analysis Services instance parameters..............................................................................39
Flight Recorder.........................................................................................................39
Random File Access..................................................................................................39
Contents 3
Comentarios a estos manuales