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)
Hardware configuration
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 will need MDAC Version 2.7 or higher.
Database Analyzer analyzes the performance of the database at regular intervals. The rules and commands for how Database Analyzer determines performance-relevant data are defined in the configuration file.
More information: Database Analyzer Configuration File
The results of the analysis are written to the Database Analyzer log files.
More information: Database Analyzer Log Files
It uses a range of pre-defined messages.
More information: Database Analyzer Messages
SAP Note 530394 (Bottleneck Analysis with Database Analyzer).