How to log DeadLocks.. |
|
For some reason our monitoring tool was not picking up deadlocks that a customer was experiencing. Needed to see the deadlocks. So here we go
DBCC TRACEON (1204,-1)
This will turn on the logging of deadlocks from a global perspective for all DBs.
If you are using Read Committed SnapShot Isolation you might find that you will still get DeadLocks. Check out this KB regarding the bug.
http://support2.microsoft.com/kb/2923460
DBCC TRACEON (1204,-1)
This will turn on the logging of deadlocks from a global perspective for all DBs.
If you are using Read Committed SnapShot Isolation you might find that you will still get DeadLocks. Check out this KB regarding the bug.
http://support2.microsoft.com/kb/2923460