Database Analyzer
Database Analyzer Basics:
Interpretation of Database Analyzer Output
|
|
Area of Use
Database Analyzer is used to analyze performance bottlenecks of MaxDB and liveCache instances starting with MaxDB-Versions < 7.5.
 | Handy Hint
The database analyzer should always run while a MaxDB/liveCache is online.
For the detailed measurement of time, the measurement of time must be switched on via the database console (DBMCLI command db_cons or tool x_cons ). 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 DBMCLI
You can also start Database Analyzer by means of Database Studio or DBMCLI as follows:
Database Studio: Mark the Database Instance and use context menu to choose Database Analazyer.
dbmcli -d <db_name> -u <dbm_user>,<password> dban_start <options>
Here, the DBM server calls up Database Analyzer using the database name and the user SYSDBA 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 <db_name> -u <dbm_user>,<password> dban_stop
You can determine the status of Database Analyzer with the following command:
dbmcli -d <db_name> -u <dbm_user>,<password> dban_state
back to top
Start/Stop Using SAP System
In the SAP system Database Analyzer can be started, stopped and analyzed using transaction DB50 -> 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 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 transaction DB50, 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
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 transaction DB50 or 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
