SAP SE
Database blocking detection

Abstract:

Various embodiments of systems and methods for detecting database blocking are described herein. The method includes detecting a non-responding state of an application. Once the non-responding state is detected, a request is sent to a database to retrieve blocking information related to the application. The blocking information is received from the database. The blocking information indicates whether the non-responding state of the application is due to database blocking or other issues. When the non-responding state is detected due to the database blocking, the blocking information also indicates whether the application is a victim or the application is a root blocker. When the application is the victim, one or more IDs and contact information related to the root blocker is provided to resolve database blocking, e.g., by discussion. When the application is the root blocker, IDs and contact information related to one or more victims of the application is provided.