HP ProLiant DL980 G7 Server - Manual (Page 35)

To ensure you have the most helpful and up-to-date recommendations, first collect data for the
workload of concern, then view the Summary page (and if needed, download the PowerShell
script). Some recommendations are based on the data collection. For more information about data
collection, see
“Collecting data for analysis and optimization recommendations” (page 31) .
NOTE:
•
By default, the Summary page and PowerShell script downloaded from it include only those
recommended settable parameter values that differ from the values currently in effect. You can
change the default behavior of the Summary page so that it displays all recommended values,
including those that do not differ from the values currently in effect. Likewise, you can modify
how the PowerShell script is generated, causing all recommended values to be included in
the script. For more information, see
“Modifying how the Summary page displays and generates
recommended values” (page 36) .
•
The Summary page and PowerShell script omit static recommendation statements regarding
unsettable parameters. To view these recommendation statements as well as all recommended
optimization values (including those that differ from the current values), go to the corresponding
optimization page.
•
The generated PowerShell script may only be executed on the same server where it was
generated. Copying and running this script to another server can cause unexpected
performance degradation.
•
The PowerShell script generated from the Summary page does not support the following two
Storage page parameters: User Write Cache Setting and Cache Power Protection.
IMPORTANT: 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 the Summary page or any other page that depends
on up-to-date data. (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.
Figure 31 (page 36) shows an example of the Summary page. For information about how to
download a generated PowerShell script from the page, see “Downloading the PowerShell script”
(page 36) .
Optimizations pages: Viewing and controlling optimization recommendations 35