beautypg.com

HP ProLiant DL980 G7 Server User Manual

Page 69

background image

Figure 58 Workload and Performance History page

To view and/or export a report, follow these steps:

IMPORTANT:

To ensure that reports are most relevant and up-to-date, perform data collection

and complete the process prior to generating or exporting a report. This saves an up-to-date CSV
data collection log file that you can use as the basis of your report (select the file in step 1).

Whenever major SQL Server configuration changes are made while the current ESO Admin Session
is active, rerun data collection prior to viewing or generating reports. (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.

1.

In the first field in the Specify Data Report file section, click the drop-down menu (

) button

on the right to list the available CSV data collection log files, and select the file you want to
view. To view a report based on the most recently-collected data, select the most recent log
file, as denoted by the file name.

2.

If you want to export this file, select the desired export file format (XML or CSV) and click
Generate File.

Right-click the file name to open or save the file, as shown in

Figure 59 (page 70)

. If you

choose to generate an XML file, you can open the file in your browser. To export the file to a
specific destination, select Save target as... and indicate the location.

Reports pages: Viewing workload/performance data and saving/restoring SQL configurations

69