The “Lock Time-outs by Lock Type” section reports on the 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 time-out. The detail rows that show the lock types are printed only if lock time-outs occurred during the sample period. If no lock time-outs occurred, the “Total Lock Time-outs” row is displayed with all values equal to 0.
For more information on lock time-outs, see “Lock timeouts” on page 75 Performance and Tuning: Locking.
