The Dead Locks grid shows a listing of deadlocked objects and related information on the processes involved.
Deadlocks occur more frequently as the lock contention increases on a server. This is particularly true with long-running transactions that run concurrently in the same database. This contention decreases concurrency.
There are several methods for reducing lock contention, such as changing the locking scheme, avoiding table locks, and not holding shared locks.
Additionally, ensure that the application acquires locks on objects in the same order. Well designed applications can minimize deadlocks by always acquiring locks in the same order. Updates to multiple tables should always be performed in the same order.
The following table describes the columns on this grid:
|
Column |
Description |
|
Time Resolved |
Time when the deadlock was resolved |
|
Database Name |
Name of the database for the deadlocked object |
|
Object Name |
Object name of the deadlocked object |
|
Victim KPID |
KPID of the victim process for the deadlock |
|
Held KPID |
KPID of the process holding the lock |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
