Locks with Waiters

Use this report to view information about the locks with waiters on a database server.

The report displays the following information for each lock:

Database

The name of the database on which the locks are held.

Table name

The name of the table on which the locks are held.

Owner Session ID

The session ID of the lock owner.

Owner

The user name of the lock owner.

Waiter Session ID

The session ID of the first waiter on the lock.

Waiter

The user name of the first waiter on the lock.

Wait Time

The length of time that the first waiter on the lock has waited for lock to be removed in this format: D HH:MM:SS.

Lock ID

The ID of the lock.

Lock Type

HDR: Header

B: Bytes

S: Shared

X: Exclusive

I: Intent

U: Update

IX: Intent-exclusive

IS: Intent-shared

SIX: Shared, intent-exclusive

Row ID

The ID of the row on which the lock is held.

Key

The key number for the row on which the lock is held.

Lock Start Time

When the lock started.

Lock Duration

The duration of the lock in this format: D HH:MM:SS.