You can use SAP MaxDB Database Analyzer to analyze the performance of databases and identify problems in the following areas:
Database configuration (caches, parameters)
Synchronization (locks, critical sections, heap)
Processing of SQL statements (for example, search strategies, indexes, optimization statistics)
You can analyze all database types and versions and also access databases on remote computers.
You can use Database Analyzer on all operating systems supported by the database system. It is a component of the SAP MaxDB software.
Database Analyzer is integrated into Database Studio and CCMS. However, you can also call Database Analyzer directly from the command line or from Database Manager CLI program.
On Microsoft Windows, Database Analyzer uses MDAC (Microsoft Data Access Components). You need MDAC Version 2.7 or higher.
Database Analyzer analyzes the performance of the database at regular intervals.
The configuration file determines how Database Analyzer collects performance-relevant data.
More information: Database Analyzer Configuration File
Database Analyzer writes the results of the analysis to log files.
More information: Database Analyzer Log Files
In the log files, pre-defined messages are used.
More information: Database Analyzer Messages
SAP Note 530394 (Bottleneck Analysis with Database Analyzer)