Monday, March 23, 2009

Viewing Deadlocks in Sql Server

Go to Sql Profiler
New Trace
Events Selection -> Locks -> Choose Deadlock graph and DeadLock chain
Run
Search for word deadlock

No comments: