This Knowledge Base Article (KBA) is part of a series of HANA Operation Recommendations. Its focus is to provide best practise instruction on handling of HANA Alerts related to blocked transactions.
A long-lasting lock situation is presently observed on the SAP HANA Database:
- Alert “Long-running blocking situations” (Alert ID 49) – “Transaction <X> has been blocked by transaction <Y> for more than <N> minutes“ has been raised by the SAP HANA Database.
- End-Users report that an application behaves slow, unresponsive. It may seem to hang or even results in a dump (time-out).
Instructions in this Knowledge Base Article have been created on a SAP HANA Database with Revision 71 (Support Package Stack SPS 7) and may differ in other revisions.
KBA , HAN-DB-MON , SAP HANA Monitoring , SV-PERF , Performance Problems , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.