Use this page to view the current resource locks on this server.
Shows the process ID (PID) of a process that has issued a lock or wishes to issue a lock.
Shows a resource ID allocated to the locked resource for the purposes of linking the information in the Lock Ownership part of the table with the information in the Resource Details part of the table.
Shows the type of lock.
Shows the state of the lock. Possible states are:
| Controlled | The requester has control of the resource |
| Waiting | The requester is waiting to gain control of the resource (synchronous request) |
| Pending | The requester has issued the request but has continued with other work (asynchronous request) |
Shows how long the lock lasts. Possible values are:
| LUW | The lock lasts until the logical unit of work ends |
| Task | The lock lasts until the task ends |
| Lock Manager | There is no implicit release of the lock. |
| Process | The lock lasts until the process ends |
Shows a resource ID allocated to the locked resource for the purposes of linking the information in the Lock Ownership part of the table with the information in the Resource Details part of the table.
Shows the lock namespace.
Length of the resource name in characters.
Shows the name of the resource given to it by the requester.