HP ProLiant DL980 G7 Server User Manual
HP Computer hardware
HP Enterprise SQL Optimizer (HP ESO) 3.6
User Guide
Abstract
This document describes how to install and use HP's Enterprise SQL Optimizer (HP ESO) software. HP ESO is designed 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.
HP Part Number: AM426-9013F
Published: October 2013
Edition: 1.0
Table of contents
Document Outline
- HP Enterprise SQL Optimizer (HP ESO) 3.6 User Guide
- Contents
- 1 Introduction
- 2 Installing HP ESO
- 3 Configuring user accounts to enable access to SQL Server and Analysis Services instances
- 4 Using HP ESO
- Getting started
- Launching HP ESO
- Getting Started pages
- Quick start: Tasks performed in a typical HP ESO user session
- Floating help for items on a page
- Starting an authenticated Administrator Session (Admin Session)
- SQL Login page: Setting credentials and logging in to SQL Server and Analysis Services instances
- Modifying the Admin Session timeout value
- Settings pages: Setting parameters for data collection
- Optimizations pages: Viewing and controlling optimization recommendations
- Summary page: Viewing recommended optimization values for settable parameters obtained from all optimization pages; generating a PowerShell script for setting these recommended values
- SQL Server page: Viewing and controlling SQL Server and Analysis Services parameters and optimization recommendations
- SQL Server database instance parameters
- Analysis Services instance parameters
- Flight Recorder
- Random File Access
- Low Memory Limit
- Total Memory Limit
- Coordinator Query Balancing Factor and Coordinator Query Boost Priority Level
- Enable Rolap Distinct Count On DataSource
- Process Min Threads
- Vertipaq Memory Limit
- Resource Monitor
- Server modes (Multidimensional Mode, Tabular Mode, Sharepoint Mode)
- Database page: Viewing and controlling database parameters and optimization recommendations
- CPU page: Viewing and controlling CPU assignment parameters and optimization recommendations
- SQL Startup Option page: Viewing and controlling SQL Server startup options
- Storage page: Viewing and controlling storage parameters and optimization recommendations
- Network page: Viewing and controlling network parameters and optimization recommendations
- System page: Viewing and controlling system parameters and optimization recommendations
- Reports pages: Viewing workload/performance data and saving/restoring SQL configurations
- Help pages: Viewing and searching help topics
- Using a PowerShell script to apply all recommended optimization values of settable parameters and to initialize software discovery
- Getting started
- 5 Troubleshooting
- 6 Support and other resources
- 7 Documentation feedback