Bottlenecks

The Database Analyzer user menu contains, among other things, a bottleneck analysis. You can display the logs of the Database Analyzer. You can stop and start the Database Analyzer, for example, to change the settings for the collection interval. You can also manage the performance data.

Prerequisites

Prerequisites

Database Analyzer must be running.

Procedure

In the Database Assistant, select Problem Analysis ® Performance ® Database Analyzer ® Bottlenecks.

...

Result

You see the results of today’s Database Analyzer bottleneck analysis ( log dban.prt), if there is one.

Each warning or information message is shown in a separate line. Double-click a line of the log to see all the Database Analyzer log entries for this line. Choose Expand All to see the entire Database Analyzer log.

See also:

List of the Database Analyzer messages: Messages

Displaying Further Performance Data

·        If you want to see the results of another day’s Database Analyzer bottlenecks analysis, choose Edit ® Choose Analysis Day.

·        If you would like to view the monitor class logs (analysis report) from the Database Analyzer and the collected performance data (aggregated data), switch to Goto ® Expert Analysis at Expert Analysis.

Changing the Collection Interval

If you need to change the collection interval for performance data, proceed as follows:

...

       1.      Choose Bottleneck Analysis ® DB Analyzer ® Stop Analysis in the Bottleneck user menu.

       2.      Choose Bottleneck Analysis ® DB Analyzer ® Start Analysis.

       3.      Specify a collection interval for the performance data.

Managing Performance Data

Choose Goto ® Managing Performance Data in the Bottleneck user menu. You can execute any administration activities automatically or manually:

·        Transfer the log files from the Database Analyzer to the database

·        Delete the log files from the Database Analyzer

·        Collect (aggregate) performance data from the Database Analyzer

See also:

Managing Performance Data

Displaying a Log Report

To view more Log files from the Database Analyzer, proceed as follows:

Choose Goto ® Self-Monitoring® <DBAN.err | DBAN.inf | DBAN.pid | DBAN.sid> in the Bottlenecks user menu.

See also:

Display in the database Alert Monitor: Database Analyzer

For more analysis, use the SQL Performance display, amongst other things.