SQL Locks

In the Problem Analysis user menu, you can, among other things, display all active and requested locks.

Exclusive locks mean that other users cannot access the locked entry. These locks can significantly interfere with the performance of the SAP system and the database system.

Prerequisites

Prerequisites

Procedure

In the Database Assistant, choose Problem Analysis ® SQL Locks.

...

Result

The following views are available:

?     Wait Situations (Exclusive)

?     Overview of SQL Locks

Determining the User Who Triggered a Lock

In a database belonging to an SAP system the name of a standard user could be SAPR3. You can use the Task Manager to find the task ID (ID) and the corresponding application PID and application server.

Then use the process overview (transaction SM50) or the application server overview (transaction SM51) to find out which SAP work process triggered the lock request or lock.