HP ProLiant DL980 G7 Server User Manual
Page 69
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
. 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