HP ProLiant DL980 G7 Server - Manual (Page 3)

Contents
1 Introduction...............................................................................................6
Features..................................................................................................................................6
New features in release 3.0.......................................................................................................7
New features in release 2.0 and 2.1...........................................................................................8
2 Installing HP ESO.......................................................................................9
Software requirements...............................................................................................................9
Installing the software................................................................................................................9
Uninstalling the software..........................................................................................................11
Upgrading the software...........................................................................................................11
Silent installation....................................................................................................................12
3 Using HP ESO..........................................................................................13
Starting HP ESO.....................................................................................................................14
Configuration steps prior to using HP ESO.................................................................................17
Ensure HP ESO user accounts have Microsoft SQL Server administrator privileges.......................17
Ensure HP ESO user accounts have Microsoft Analysis Services administrator privileges...............18
Getting Started.......................................................................................................................20
Quick start: basic session....................................................................................................21
Floating help.....................................................................................................................24
Creating an authenticated Administrator Session (Admin Session).............................................25
SQL Server Login: Setting credentials and logging into SQL Server and Analysis Services
instances..........................................................................................................................25
Modifying the Admin Session timeout value...........................................................................27
Settings pages.......................................................................................................................27
Data Collection page: Collecting data for analysis and optimization recommendations...............27
Optimizations pages...............................................................................................................29
SQL Server page: Viewing and enabling SQL Server and Analysis Services optimization
recommendations..............................................................................................................31
SQL Server database instance parameters........................................................................32
Maximum Degree of Parallelism.................................................................................32
Lightweight Pooling...................................................................................................32
Priority Boost............................................................................................................32
Minimum Server Memory (in MB)...............................................................................33
Maximum Server Memory (in MB)..............................................................................33
CheckPoint..............................................................................................................33
Lock Pages in Memory..............................................................................................33
MaxWorkerThreads..................................................................................................33
Xp_CmdShell...........................................................................................................33
Analysis Services instance parameters..............................................................................34
Flight Recorder.........................................................................................................34
Random File Access..................................................................................................34
LowMemoryLimit.......................................................................................................34
TotalMemoryLimit.....................................................................................................34
CoordinatorQueryBalancingFactor and CoordinatorQueryBoostPriorityLevel.....................34
EnableRolapDistinctCountOnDataSource.....................................................................34
Database page: Viewing and enabling database optimization recommendations.......................35
SQL Server Database Engine properties...........................................................................36
File Growth..............................................................................................................36
Auto Create Statistics................................................................................................36
Auto Update Statistics...............................................................................................36
Auto Update Statistics Async......................................................................................36
Contents 3