HP ProLiant DL980 G7 Server User Manual
HP Computer hardware
Table of contents
Document Outline
- HP Enterprise SQL Optimizer (HP ESO) 3.5 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