SQL server Event Notification for lock timeouts | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
SQL server Event Notification for lock timeoutsHi I am trying to use event notification on SQL 2005 to monitor Lock:Timeouts only. all i see for lock tracing are
, , LOCK_DEADLOCK_CHAIN, LOCK_DEADLOCK, LOCK_ESCALATION
does anyone of these actually track lock timeouts or am i missing any one in particular? please help.
EVENT NOTIFICATION LockNotificationEventON
See this http://msdn.microsoft.com/en-us/library/ms190916(SQL.90).aspx * http://msdn.microsoft.com/en-us/library/ms189107(SQL.90).aspx BOL notes, also if you have obeserved too many lock timeouts count then that lock timeouts counter can be misleading in that it includes lightweight internal lock timeouts that are basically normal. Unless you have changed your lock timeout setting from the default.