Monitoring Write Intent Locks in Interactive SQL

View details on write intent locks using the sa_locks system procedure.

1. Run the sa_locks system procedure.
2. View the lock_class column, which shows intent locks for tables and rows.
3. Run the sp_iqlocks stored procedure to identify users who are blocking other users from writing to a table. This procedure displays information about locks currently held in the database, including the connection and user ID that holds the lock, the table on which the lock is held, the type of lock, and a name to identify the lock.

• Write-Intent Locks
  A write-intent lock is a table write lock that grants the transaction permission to write to a table row in the future. A write-intent lock can be held by multiple requesting connections.