Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

SAP® MaxDB - Database Analyzer

 

 

Moderators: Christiane Hienger

WIKI Space Editor: Thiago Lüttig.

 

Database Analyzer is used to analyze performance bottlenecks of SAP MaxDB and liveCache databases.

 

Details

Handy Hint

The database analyzer should always run while a SAP MaxDB/liveCache is in operational state ONLINE.
For the detailed measurement of time, the measurement of time must be switched on via the database console (DBM command db_cons or tool XCONS). However, this time measurement should not run all the time because this affects performance.

You can use database analyzer to 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

The database analyzer classifies analysis messages by information and warning (two warning levels). In the dbanalyzer<version>.cfg configuration file, SAP defines rules and commands which are used by database analyzer when determining performance-relevant information.The configuration file also describes the classes (information, levels of warnings, error messages) that database analyzer uses to analyze the parameters: The messages are logged in the DBAN.prt log file.
back to top

Start/Stop Using Database Studio or Database Manager CLI

You can also start Database Analyzer by means of Database Studio or Database Manager CLI (DBMCLI) as follows:

Database Studio: Mark the database and use context menu to choose Database Analyzer.

Database Manager CLI : dbmcli -d <database_name> -u <dbm_operator>,<password> dban_start <options>

Here, the DBM server calls up database analyzer using the database name and the user DBM operator and, in addition, also the options transferred with the command (for example,
-t 900). If database analyzer is already active, this command only transfers the status.

Database analyzer is stopped with the following command:

dbmcli -d <database_name> -u <dbm_operator>,<password> dban_stop

You can determine the status of database analyzer with the following command:

dbmcli -d <database_name> -u <dbm_operator>,<password> dban_state

back to top

Start/Stop Using SAP System

In the SAP system Database Analyzer can be started, stopped and analyzed using database assistant (transaction DB50) or DBA Cockpit (transaction DBACOCKPIT) -> Problem Analysis -> DB Bottlenecks. You should consider the following release dependencies:

46C as of Basis SP 43,
46D as of Basis SP 32,
6.10 as of Basis SP 31,
6.20 as of Basis SP 20,
6.40 and 7.00 from the beginning
Furthermore, database parameter INSTANCE_TYPE must be maintained.

Useful Information

Database analyzer is automatically started for the database of the SAP system when the SAP system is started from the following Basis SPs: 4.6C SP 46, 4.6D SP 35, 6.10 SP 38, 6.20 SP 35, 6.40 and 7.00 from the beginning.

You can deactivate the automatic start as of the following Basis SPs: 4.6C SP 51, 4.6D SP 41, 6.10 SP 44, 6.20 SP 54, 6.40 SP 14 and 7.00 SP 04.
For SAP liveCache the automatic start can already be setup in the integration data as of the following Basis SPs: 4.6C SP 41, 4.6D SP 30, 6.10 SP 29, 6.20 SP 18, 6.40 and 7.00 from the beginning.
If you start database analyzer (Start Analysis), you have to specify the interval during which data is collected. For routine monitoring of database operation in the production system, an interval of 15 minutes (900 seconds) is adequate. For short-term monitoring of database operation, a measuring interval of 60-120 seconds is recommended.
You stop database analyzer using Stop Analysis.
back to top

Current Status of Database Analyzer

If you want to see the current status of database analyzer in database assistant (transaction DB50) or DBA Cockpit (transaction DBACOCKPIT), choose Determine Status in the database analyzer menu.

You can then also see where the configuration file of database analyzer is located and where the logs are stored.

back to top

Display the Database Analyzer output in SAP System

You can use database assistant (transaction DB50) or DBA Cockpit (transaction DBACOCKPIT) -> Performance -> Database Analyzer to choose between the bottleneck and the expert analysis. We recommend that for a first analysis, you use the Bottlenecks menu path.

back to top

Database Analyzer History data

If you wish to look at the analysis logs of past days, choose Select Analysis Day.

back to top

Advanced Analysis

You can use Advanced Analysis to look at the detailed logs of the individual analysis days.

back to top

Aggregation of collected Data

As of the following Basis SPs the aggregation of the collected database analyzer data is possible in database assistant (transaction DB50) or DBA Cockpit (transaction DBACOCKPIT) or liveCache assistant (transaction LC10) (Advanced Analysis -> Performance Data Administration):
4.6C Basis SP 48,
4.6D Basis SP 37,
6.10 Basis SP 40,
6.20 Basis SP 42,
6.40 Basis SP 05,
7.00 Basis SP 00.
The aggregated data is displayed in Advanced Analysis -> Aggregated Performance Data.

back to top