Poti vedea blocajele si in "activity monitor".
Incearca si:
http://www.extremeexperts.com/SQL/Yukon/DeadLockDetection.aspx
http://sqlserver.ro/forums/thread/5119.aspx
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/04/06/event-notifications-monitoring-blocked-processes-and-other-events-end-to-end-how-to-set-it-up-and-make-it-work.aspx