Hp ProLiant DL980 G7 Server User Manual download pdf (Page 37)

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 37).

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 75).

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 37) 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.

Optimizations pages: Viewing and controlling optimization recommendations 37

1 2 ... 32 33 34 35 36 37 38 39 40 41 42 ... 80 81

No comments

Hp ProLiant DL980 G7 Server User Manual Page 37