Symptom
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).
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
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.
Keywords
KBA , HAN-DB-MON , SAP HANA Monitoring , SV-PERF , Performance Problems , 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.