Lock Time-out Information

Number of times a task was waiting for a lock and the transaction was rolled back due to a session-level or server-level lock timeout. The detail rows that show the lock types are printed only if lock timeouts occurred during the sample period. If no lock time-outs occurred, “Total Lock Time-outs” is displayed with all values equal to 0.

For more information on lock time-outs, see Chapter 4, “Using Locking Commands,” in Performance and Tuning Series: Locking and Concurrency Control.