Hi I am trying to use event notification on SQL 2005 to monitor Lock:Timeouts only. all i see for lock tracing are DEADLOCK_GRAPH , , 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. code snippetCREATE EVENT NOTIFICATION LockNotificationEventON SERVER FOR
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.
