Show TOC

Expert AnalysisLocate this document in the navigation structure

Use

The Database Analyzer user menu of the DBA Cockpit contains a Load History. You can view the logs of the monitor classes (analysis areas) and manage the performance data.

Procedure

Open the DBA Cockpit (transaction code DBACOCKPIT) and choose Start of the navigation path Performance Next navigation step Database Analyzer Next navigation step Expert Analysis End of the navigation path.

It is also possible to go into the load history from the Bottlenecks user menu via Start of the navigation path Goto Next navigation step Expert Analysis End of the navigation path.

Result

The Database Analyzer logs ( DBAN.prt, DBAN_<Monitorklasse>.csv) can be displayed in the load history by day. Select the desired day and expand the display. You can open the logs for further analysis by double-clicking.

Collected (Aggregated) Performance Data

If you would like to view the collected performance data (aggregated data), expand the desired performance data in the Load History.

Double-clicking within an aggregation level ( daily aggregates, weekly aggregates, monthly aggregates, quarterly aggregates) takes you to the display of the corresponding Database Analyzer file, classified according to monitor classes and time periods. You can also reach the overview of the respective daily aggregates for the period from the weekly, monthly and quarterly aggregates.

If you want to store the aggregated performance data locally, choose  Start of the navigation path Export End of the navigation path. Choose an appropriate subdirectory on your local computer and start the procedure. The data is stored in the   analyzer subdirectory.

Managing Performance Data

Choose Start of the navigation path Edit Next navigation step Managing Performance Data End of the navigation path in the Load History. You can execute the following administration activities automatically or manually:

  • Transferring the log files from the Database Analyzer to the database

  • Deleting the log files from the Database Analyzer

  • Collecting (aggregating) performance data from the Database Analyzer

See also: Managing Performance Data

More Information

Database Analyzer, Database Analyzer Log Files