SAP Knowledge Base Article - Preview

3206193 - Slowness when executing DBACOCKPIT

Symptom

You notice slowness when executing DB related t-codes like DBACOCKPIT, DB02,etc.   In ST12 trace, you notice that the long running SQLs are accessing M_SERVICE_REPLICATION or M_SYSTEM_REPLICATION.  SQLs like:

a0adfca9b52ccf6778f8d5d0e1efb0cb
SELECT secondary_site_name, operation_mode FROM SYS.M_SYSTEM_REPLICATION;

b00125455f78c4d794fba903eea620aa
SELECT REPLICATION_STATUS, COUNT(*) FROM SYS.M_SERVICE_REPLICATION WHERE VOLUME_ID <> 0 GROUP BY REPLICATION_STATUS;


Read more...

Environment

SAP HANA database 1.0 

SAP HANA database 2.0 

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

DBACOCKPIT, a0adfca9b52ccf6778f8d5d0e1efb0cb, b00125455f78c4d794fba903eea620aa, M_SERVICE_REPLICATION, M_SYSTEM_REPLICATION , KBA , HAN-DB-PERF , SAP HANA Database Performance , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.