HP ProLiant DL980 G7 Server - Manual (Page 13)

3 Using HP ESO
HP ESO allows you to connect to SQL Server and Analysis Services instances to perform a variety
of operations to help with system configuration and tuning to optimize SQL performance.
Table 1
(page 13) lists the main tasks you can perform using HP ESO.
Table 1 Tasks to perform
For more information... Task to perform...
Configuration steps prior to using HP ESO
“Starting HP ESO” (page 14) Launch HP System Management Homepage (SMH) to start HP ESO
“Configuration steps prior to
using HP ESO” (page 17) Ensure that user accounts have correct privileges to access SQL Server and Analysis
Services instances
Tasks to perform using HP ESO
“Getting Started” (page 20) Getting started: perform a basic session and get help
“Creating an authenticated
Administrator Session (Admin
Session)” (page 25) Start an individual, authenticated session to enable access to ESO pages and
functionality
“SQL Server Login: Setting
credentials and logging into SQL Enter login credentials and authentication type for SQL Server and Analysis Services
instances; log in to SQL instances
Server and Analysis Services
instances” (page 25)
“Modifying the Admin Session
timeout value” (page 27) Modify Admin Session timeout period
“Data Collection page: Collecting
data for analysis and Set data collection parameters and initiate data collection and analysis for
optimization recommendations
optimization recommendations”
(page 27)
“SQL Server page: Viewing and
enabling SQL Server and View SQL Server and Analysis Services information and enable optimization
recommendations
Analysis Services optimization
recommendations” (page 31)
“Database page: Viewing and
enabling database optimization
recommendations” (page 35) View information about database files in each SQL Server and Analysis Services
instance and enable optimization recommendations
“Database page: Viewing high
availability and disaster recovery
configurations” (page 37) View information about high availability and disaster recovery database
configurations
“SQL Server page: Viewing and
enabling SQL Server and View information about CPU-thread associations and enable optimization
recommendations
Analysis Services optimization
recommendations” (page 31)
“Storage page: Viewing and
enabling storage optimization
recommendations” (page 42) View storage information and enable optimization recommendations
“Network page: Viewing and
enabling network optimization
recommendations” (page 43) View network information and enable optimization recommendations
“SQL Startup Option page:
Viewing and enabling startup
options” (page 45) View SQL startup information and set trace flags to modify SQL Server behavior
13