SQL Server Profiler
Of course, deadlocks are not typically going to happen while you watch, so how can you know when and why they occur? You can use either...
Recent Posts
Archive
Tags
SQL Server Profiler
Lock Events Category
Application lock
Locking behavior
WITH NOCHECK
ABOUT "ROWLOCK"
Enable row versioning for lock
Case study -- About deadlock
Acquiring locks
Isolation levels