HP ProLiant DL980 G7 Server - Manual (Page 38)

2. After the script is generated, a link to the script appears further to the right of the button, as
shown in
Figure 32 (page 38) .
Figure 32 PowerShell script link
3. Right-click the link and save the script, removing the .txt extension. For example, save the script
shown in the preceding example as file named:
ESO_All_Recommendations_20130715_032650.ps1
4. To edit and run the script, follow the directions provided in “Using the PowerShell script to
apply HP ESO optimization recommendations for all settable parameters” (page 76) .
SQL Server page: Viewing and controlling SQL Server and Analysis Services
parameters and optimization recommendations
The SQL Server page contains recommendations for setting parameters for SQL Server and Analysis
Services instances. The SQL instances displayed on the page are grouped into the following types:
•
SQL Server instances
Database Engine (OLTP) ◦
◦ Data Warehouse (DW)
◦ SAP Database Engine
•
Analysis Services instances
Figure 33 (page 38) shows an example of the SQL Server page.
Figure 33 SQL Server page
The following subsections describe the parameters affecting SQL Server optimization.and memory
allocation
NOTE: HP ESO calculates memory allocation recommendations for all active instances. If you
have not provided valid credentials for certain instances, HP ESO displays the recommendations
for these instances only after you have logged in to them with valid credentials.
38 Using HP ESO