3570417 - How to enable log_replay_detailed_statistics to collect log replay statistics information in SAP HANA secondary site

Symptom

Log replay is delay in secondary site, while there is no obvious resource shortage in secondary site like OOM issue.
By enable following parameter, runtime dump "<service>_<host>.<port>.rtedump.<timestamp>.<pid>.LogReplayDetailedStatistics.trc" would be created at the end of a log replay.

global.ini -> [persistence] -> log_replay_detailed_statistics = true

Additional statistics data would be available in view M_LOG_REPLAY_QUEUE_STATISTICS and M_LOG_REPLAY_QUEUE_DETAILED_STATISTICS_ as well.
Runtime dump would provide the data in those views from secondary site regarding log replay for root cause analysis.

Environment

SAP HANA 2.00.044.00 or higher

Keywords

Redo done up to position, log replay, hang, delay, latency, system replication, logreplay, container_id , KBA , HAN-DB-HA , SAP HANA High Availability (System Replication, DR, etc.) , How To

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.