ShowWaitingLocks

Table of Contents

Overview
Shows all processes that are currently waiting on a lock an provides information about those locks.

ProcessId - the process which is waiting.
Granularity - the granularity of the lock the process is waiting to acquire. File, directory, etc.
Operation - the operation of the lock the process is waiting to acquire. Read, write, delete, stability, etc.
ObjectName - the object that the process is waiting to acquire a lock on.

Shows waiting locks for all processes.

Exec ShowWaitingLocks

Shows waiting locks for a specific process.
for the process id 1.

Exec ShowWaitingLocks 1