Database Analyzer 

In the Performance user menu you can also find the tool Database Analyzer for bottleneck analysis.

When a liveCache database instance is started, the Database Analyzer starts to collect data. The Database Analyzer generates log files that are saved to the liveCache computer.

For more information about the Database Analyzer, see the Database Analyzer documentation.

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 is automatically started when the liveCache database instance is started. It should always remain activated (Automatic Monitoring). The default collection interval for the performance data amounts to 900 seconds.

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.

Result

The following performance analysis options are available:

·        Bottlenecks

·        Expert Analysis

Starting the Database Analyzer Explicitly

If necessary, you can start the Database Analyzer explicitly in the following ways:

...

       1.      Choose Bottleneck Analysis → DB Analyzer → Start Analysis.

       2.      Specify a collection interval for the performance data.