Skip to main content
Skip table of contents

MSS_DB02_BLOCKS - MS SQL Database Blocking Locks

Data Description

The MSS_DB02_BLOCKS event is used in SAP to provide an overview of the Blocking Locks (wait situations that are currently caused by database locks) on MS SQL Database.

Potential Use Cases

This event could be used in the following scenarios:

  • Determine an overview of Blocking Locks (wait situations that are currently caused by database locks) on MS SQL database.

  • Monitor to determine if critical blocking locks are present and send alerts

  • Determine how frequently the blocking locks occur and on which data-based table

  • Can be used to find which Programs/Transactions are responsible for blocking locks and schedule the execution of such transactions accordingly

SAP Navigation

Log in to the SAP ECC system (having MS SQL database) and execute the transaction DBACOCKPIT. Navigate to Performance->Locks. The ‘Blocking Locks’ sub-screen of the Lock entrance screen displays the list of blocking locks.

image-20240321-033502.png

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.