Hp ProLiant DL980 G7 Server User Manual Page 34
- Page / 82
- Table of contents
- TROUBLESHOOTING
- BOOKMARKS
Rated. / 5. Based on customer reviews
Figure 28 Performance Monitor
Optimizations pages: Viewing and controlling optimization
recommendations
The Optimizations pages provide various types of optimization recommendations based on collected
data.
IMPORTANT: HP highly recommends that you run data collection and complete the process
before visiting or modifying the optimization pages. To ensure suitability of HP ESO’s optimization
recommendations, perform data collection during typical business workloads.
Whenever major SQL Server configuration changes are made while the current ESO Admin Session
is active, rerun data collection prior to using Optimizations pages. (Examples of major configuration
changes include adding or removing an SQL instance, database, or database file.) Data that was
collected prior to a major configuration change will likely be obsolete. Rerunning the data collection
ensures that optimization recommendations and reports are aligned to the current configuration
and workload.
If you have used a domain user account to log into SQL instances, Optimizations pages may take
a few minutes to load the first time after logging in to the SQL instances or completing data
collection, as HP ESO initially gathers data from multiple sources and calculates optimization
recommendations.
HP ESO optimization pages typically display the following values or controls (see Figure 29
(page 35)):
• N/A ⇒ No recommendation can be provided for the parameter at the current state and
environment.
• Current ⇒ The current parameter value discovered in the system.
• Recommended ⇒ The parameter value recommended by HP ESO.
• New Value ⇒ This field contains the new parameter value to be applied to the system. By
default, this field contains the recommended value. However, you can change this value if
desired.
• SET ALL ⇒ Sets all of the parameters shown in the New Value field on the page. Click this
button to make the changes take effect immediately. Changes requiring a system or SQL Server
service restart are indicated after the changes are applied.
34 Using HP ESO
- User Guide 1
- Contents 3
- 4 Contents 4
- Contents 5 5
- 1 Introduction 6
- New features in release 3.6 7
- New features in release 3.5 7
- New features in release 3.0 7
- 8 Introduction 8
- 2 Installing HP ESO 10
- Installing the software 11 11
- Uninstalling the software 12
- Upgrading the software 12
- Silent installation 13
- 14 Installing HP ESO 14
- In desktop mode 15
- In tile mode 15
- 4 Using HP ESO 19
- Getting started 20
- Getting started 21 21
- 22 Using HP ESO 22
- Getting Started pages 23
- HP ESO SQL Login page 24
- Getting started 25 25
- 26 Using HP ESO 26
- Getting started 27 27
- 28 Using HP ESO 28
- Getting started 29 29
- Services instances 30
- Getting started 31 31
- 32 Using HP ESO 32
- 34 Using HP ESO 34
- 36 Using HP ESO 36
- ◦ Data Warehouse (DW) 38
- ◦ SAP Database Engine 38
- 40 Using HP ESO 40
- 42 Using HP ESO 42
- ◦ Data Warehouse 43
- 44 Using HP ESO 44
- Analysis Services properties 45
- 46 Using HP ESO 46
- Figure 38 Mirrored database 48
- Cluster Network Name 49
- Computer Name 49
- Computer Role 49
- 50 Using HP ESO 50
- 52 Using HP ESO 52
- Overview 54
- 56 Using HP ESO 56
- Trace flag 8048 58
- Trace flag 834 58
- Trace flag 1117 59
- Trace flag 1118 59
- Trace flag 2371 59
- Trace flag 2549 59
- Trace flag 2562 59
- Database RAID level 60
- User Write Cache Setting 60
- Cache Power Protection 60
- Drive free space 60
- Volume mount point 61
- Drive Latency 61
- Port affinity 62
- Receive-Side Scaling 63
- NIC teaming 64
- 66 Using HP ESO 66
- PCI Controller Information 67
- Software Discovery 67
- SQL configurations 68
- Save/Rollback Configuration 70
- Accessing online help 72
- 76 Using HP ESO 76
- 78 Using HP ESO 78
- 5 Troubleshooting 79
- 6 Support and other resources 80
- Related information 81
- Typographic conventions 81
- 7 Documentation feedback 82
Related products and manuals for Computer hardware Hp ProLiant DL980 G7 Server
(127 pages)© 2020, manymanuals.com. All rights reserved. | 1.482 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals