SQLTeam.com | Weblogs | Forums

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


#1

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?

Thanks
bye
Andrew


#2

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