Performance Warehouse: Reporting

To display detailed reports, you first have to specify the time frame for which you want to analyze data by defining the following:

• Granularity

  You can choose between Hour, Day or Month. Depending on your selection, the values for your time frame might change.

• Time Frame

  If you choose Custom Selection from the drop-down list, you can manually enter the starting and ending time for your analysis. To activate your custom selection, choose Apply Filter. For any other selection from the drop-down list, the reports are automatically refreshed.

The reports are categorized and for each category there is one tab page. On every tab page, you find a button row for the reports. Every pushbutton in the button row represents a specific view on the database performance, for example, I/O, Prefetcher, Sort Heap, etc.

Displaying a Report

To display a report, choose the appropriate view pushbutton on the respective tab page.

The reports consist of two sections:

• In the upper section, a chart is displayed to visualize the key performance indicators. The chart provides a subset of the key columns from the detail table view.
  Note

  The chart display is optional and not available for all available views.

• In the lower section, a detailed table view is available.

You can drill down your reports by either using the context menu of a column header in the Detail: <Category - View> screen area or by specifying the respective value using the pushbuttons in the Detail: Navigation screen area. Here, you can also add and remove columns or key figures, or you can set filters on columns.

In addition, there are predefined exceptions (for example, Chart: Exceptions or Details: Exceptions) for almost all reports on key performance indicators. The used thresholds are based on Early Watch Alerts and each violation to these thresholds is displayed in red.