You use the data provided on the Reporting screen to analyze database performance problems in the present or the past. To access the Reporting screen of the Performance Warehouse, call the DBA Cockpit and choose Performance ® Performance Warehouse ® Reporting.
If you are using the SAP GUI-based user interface, a separate Web browser opens for this application.
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.
To display a report, choose the appropriate view pushbutton on the respective tab page.
The availability of the tab pages and of the pushbuttons on each tab page can vary depending on the selected system. Some reports are only available if special database features are enabled.
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.
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.
If you want to reset a report to its initial state, choose Reset Report in the central system area.