Solution : https://service.sap.com/sap/support/notes/725489 (SAP Service marketplace login required)
Summary :
To address performance issues in SAP systems using MaxDB, SAP Note introduces two tools: the Database Analyzer and the Command Monitor. The Database Analyzer helps in performing long-term analysis of database instances by collecting and categorizing performance data, aiding in identifying issues related to database configuration, synchronization, query processing, and hardware setup. Users can access it via transaction DB50. The Command Monitor, used for short-term analysis, logs SQL performance data to identify inefficient database accesses. It requires the setting of the 'dbs/ada/register_appl_info' parameter for detailed logging and can be accessed under the same transaction pathway.
Key words :
mysql maxdb -> database assistant -> problem analysis -> sql performance, dbs/ada/register_appl_info instance profile parameter, selecting problem analysis -> sql performance -> command monitor, database analyzer collects performance-relevant data, analyse long-running sql commands, identify long-running sql statements, database analyzerthe database analyzer program, warning levels error messages, bc-db-sdb component, reports inefficient database accesses
Related Notes :
| 994590 | High increase in the temporary data area |
| 820824 | FAQ: SAP MaxDB/liveCache technology |
| 819641 | FAQ: SAP MaxDB Performance |
| 767598 | Available SAP MaxDB documentation |
| 766827 | Composite SAP note: Performance SCM 4.0 |
| 757884 | IS-Healthcare: Additional indexes for SAP DB |
| 756826 | IS-MEDIA: Additional indexes for MaxDB |