Hp ProLiant DL980 G7 Server Bedienungsanleitung PDF herunterladen (Seite 26)

Figure 18 Left pane page selection links

4. Configure and perform data collection. To do so, access the Data Collection page by selecting

the Data Collection link (if you do not see the Data Collection page link, expand Settings ).

The data collection process generates recommendations. Before performing data collection,

make sure all the SQL instances are under the workload stress expected in real world conditions.

In addition, if major SQL Server configuration changes are made while the current Admin

Session is active, rerun data collection before using optimization pages and reports. For more

information about data collection, see “Collecting data for analysis and optimization

recommendations” (page 31).

5. Select the Summary page to view a summary of optimization recommendations for all settable

parameters. The recommendations are gathered from all the optimization pages. (By default,

the page displays only those parameters whose recommended values differ from the values

currently in effect.) The Summary page allows you to download a PowerShell script that you

can use to set the recommended values. For more information about the Summary page, see

“Summary page: Viewing recommended optimization values for settable parameters obtained

from all optimization pages; generating a PowerShell script for setting these recommended

values” (page 34). You can also view and set optimization recommendations by accessing

any of the Optimizations pages (access these by clicking any of the links under Optimizations

in the left pane of the page). These pages display current values of parameters and their

recommended values (even those recommended values that are the same as the values currently

in effect). The Optimizations pages also display recommendation statements (static strings of

26 Using HP ESO

1 2 ... 21 22 23 24 25 26 27 28 29 30 31 ... 80 81

Keine Kommentare

Hp ProLiant DL980 G7 Server Bedienungsanleitung Seite 26