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

The user has been assigned a role in accordance with the authorization concept.

You are in the user menu of the user with the authorizations that correspond to this role.

The liveCache database instance is in the ONLINE operational state.

The Database Analyzer has been started (Automatic Monitoring).

Procedure

       1.      In the user menu, choose liveCache Assistant(transaction LC10).

       2.      Enter the name of the database connection.
You can select the name from the list of existing names. You can restrict the search for the required name.

       3.      Choose liveCache → Monitoring.

       4.      Choose Problem Analysis → Performance → Database Analyzer → Bottlenecks.

Result

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

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.

More information:

List of the Database Analyzer messages: Messages

Displaying Further Performance Data

●      If you want to see another day’s results, choose Edit → Choose Analysis Day.

●      To display the logs of the monitor class (analysis areas) of the Database Analyzer and the collected performance data (aggregated data), go to Expert Analysis: Goto → 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

More information:

Managing Performance Data

Displaying Logs

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.

 

More information:

liveCache Alert Monitor, Database Analyzer

For more analysis, choose the SQL Performance display.