HP ProLiant DL980 G7 Server - Manual (Page 3)

Contents
1 Introduction...............................................................................................6
Benefits of using HP ESO...........................................................................................................6
Main features of HP ESO...........................................................................................................6
New features in release 3.6.......................................................................................................7
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....................................................................................................15
Set user account privileges in Database Engine security...............................................................15
Set user account privileges in Analysis Services security...............................................................16
4 Using HP ESO..........................................................................................19
Getting started.......................................................................................................................20
Launching HP ESO.............................................................................................................20
Getting Started pages........................................................................................................23
HP ESO Introduction page..............................................................................................23
HP ESO SQL Login page................................................................................................24
Quick start: Tasks performed in a typical HP ESO user session.................................................25
Floating help for items on a page........................................................................................28
Starting an authenticated Administrator Session (Admin Session)..............................................29
SQL Login page: Setting credentials and logging in to SQL Server and Analysis Services
instances..........................................................................................................................30
Modifying the Admin Session timeout value...........................................................................31
Settings pages: Setting parameters for data collection.................................................................32
Data Collection page: Collecting data for analysis and optimization recommendations...............32
Optimizations pages: Viewing and controlling optimization recommendations ...............................34
Summary page: Viewing recommended optimization values for settable parameters obtained from
all optimization pages; generating a PowerShell script for setting these recommended values.......35
Modifying how the Summary page displays and generates recommended values..................37
Downloading the PowerShell script..................................................................................37
SQL Server page: Viewing and controlling SQL Server and Analysis Services parameters and
optimization recommendations............................................................................................38
SQL Server database instance parameters........................................................................39
Max Degree of Parallelism.........................................................................................39
Lightweight Pooling...................................................................................................39
Priority Boost............................................................................................................39
Min Server Memory (in MB).......................................................................................39
Max Server Memory (in MB)......................................................................................39
Recovery Interval......................................................................................................39
Lock Page................................................................................................................39
Max Worker Threads................................................................................................40
Xp_CmdShell...........................................................................................................40
Analysis Services instance parameters..............................................................................40
Flight Recorder.........................................................................................................40
Contents 3