Database Analyzer: SAP DB 

Purpose

The Database Analyzer program is a tool for analyzing the performance of SAP DB database instances. It replaces the tools x_wizardand X_wiztrc.

You can use the Database Analyzer independently of the SAP DB version and the database instance type. You can also use this program to access the database instance from a remote host.

Scope of Functions

The Database Analyzer collects performance-relevant data by monitoring the performance of the database instance at regular (variable) intervals. It splits the results of its analyses into five classes – information, three different levels of warnings, and error messages.

This makes it easier for you to find out the following possible causes of problems with the database instance:

• Database configuration (caches, parameter)
• Synchronization (locks, critical regions, heap)
• Processing of database requests (such as processing strategies, indexes, optimizer statistics)
• Hardware configuration

The rules and commands for collecting the performance-relevant data are defined in a modifiable configuration file.

To be able to interpret the information gathered by the Database Analyzer, you require a sound working knowledge of the SAP DB architecture, the architecture of your SAP DB application program, and your operating system.

For general information on the SAP DB database system, see The SAP DB Database System on the SAP DB Homepage http://www.sapdb.org.