SQLTeam.com | Weblogs | Forums

How to monitor ALL locks/deadlocks running more then few seconds

Hello guys,
II'm using SQL Profiler for detecting locks, I've set up a trace with the Blocked Process report and set threshold on 5 seconds.
I've read that this event class does not include system tasks so I am worried that some locks will not be detect with this report. This report detect Deadlock or I have to set deadlock even also? Which kind of locks it can't monitor?


You should go through this nice blog to know the basics of Deadlocks in SQL Server. It will help yours. http://blogs.technet.com/b/mspfe/archive/2012/06/28/how_2d00_to_2d00_monitor_2d00_deadlocks_2d00_in_2d00_sql_2d00_server.aspx