HP ProLiant DL980 G7 Server - Manual (Page 77)

NOTE: By default, the script includes only those recommended settable values that differ from
the values currently in effect. You can change this default behavior so that the script generates all
recommended settable values, including those that do not differ from the values currently in effect.
For more information, see
“Modifying how the Summary page displays and generates recommended
values” (page 37) . The script omits static recommendation statements for unsettable parameters.
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.
Figure 67 PowerShell script downloaded from the HP ESO Summary page
You can run the PowerShell script generated from the Summary page even if the HP ESO service
is stopped. Before running the script, open and edit the script in PowerShell ISE:
1.
Launch PowerShell ISE
2. In PowerShell ISE, open the ps1 file downloaded from the Summary page.
3. To selectively apply optimization parameters (instead of applying all parameters), you can
modify the script to skip certain types of optimization parameters. To do so, modify the
corresponding $EXECUTE_ lines. For example, to skip CPU-related parameters, replace True
in the following line with False:
$EXECUTE_CPU_SETTINGS = $True
4. Insert the correct credentials for each SQL Database Engine instance at the beginning of the
script file, as the comments suggest.
5. Click the Run button in the tools bar of the PowerShell ISE or press the F5 shortcut key. All
setting results (whether settings succeeded or failed) are listed in the PowerShell ISE console.
NOTE: Microsoft Analysis Services instances use Windows Integrated Security. Therefore, there
is no need to specify login credentials for these instances.
Using the PowerShell script to initiate software discovery
The PowerShell Script for software discovery is generated when HP ESO is installed. The generated
script location and name is as follows:
C:\Program Files\McPerfOpt\Scripts\
ESO_Recommendations_Software_Discovery.ps1
This script performs the same function as does the software discovery tool on the HP ESO System
page. It can be edited and run in PowerShell ISE on the current local client system.
Using a PowerShell script to apply all recommended optimization values of settable parameters and to initialize software
discovery
77