SM12 Top Capacity Used

In transaction code SM12, you can check the lock entry usage from the menu below:

In SM12, go to Extras > Top Capacity Used > Current to see the current highest lock usage. You can also check past overflow records in SM12, go to Extras > Top Capacity Used > History.

Notes:

Current
- This menu shows the current locks in the Enqueue table, grouped by owner. It only displays users who have requested more than 20 locks.

History
- This menu is used to review lock table overflow cases. It is not meant to show the full history of all lock activity in the system. A history entry is only created when a lock overflow happens, and it shows the top 3 users responsible for that overflow.

Client
- The client where the lock was created.

Name
- The name of the user who created the lock.

Date/Time
- For Current:
  - This shows the start time of the transaction that created the lock entry.
- For History:
  - This shows the actual date and time when the enqueue overflow happened.

Lock Mode
- The lock mode used for the lock entry.

Table Name
- This field can be confusing. Top Capacity Used shows grouped data in each line, so it does not represent one specific table. The value shown in the Table Name field is actually the current date and time. Each line represents all locks for one specific owner.