Component documentationDatabase Analyzer Locate this document in the navigation structure

 

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.

Integration

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.

Features

More Information

SAP Note 530394 (Bottleneck Analysis with Database Analyzer).