SAP Knowledge Base Article - Preview

2079396 - How to handle HANA Alert 49: 'long-running blocking transaction'

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:

  1. 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.
  2. 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.