Show TOC

Database AnalyzerLocate this document in the navigation structure

Use

In the Performance user menu you can also find the tool Database Analyzer for bottleneck analysis. When the SAP system is started, the Database Analyzer starts to collect data. The Database Analyzer generates log files that are saved to the respective database server.

Prerequisites

Prerequisites

The database or SAP liveCache is in the ONLINE operational state.

Procedure

Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10). Choose Start of the navigation path Problem Analysis Next navigation step Performance Next navigation step Database Analyzer End of the navigation path.

or

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

Result

The following performance analysis options are available:

Starting/Stopping the Database Analyzer

When the SAP system or the SAP liveCache starts up, the Database Analyzer is automatically started for the system's Basis database. With other systems, you need to explicitly start the Database Analyzer. The Database Analyzer must always be activated. The default collection interval for the performance data is 900 seconds.

If necessary, you can start or stop the Database Analyzer explicitly with the Bottlenecks user menu.

For SAP liveCache you have the option of setting, with Automatic Monitoring, whether the Database Analyzer should always be activated or not.

More Information