SQL server Event Notification for lock timeouts | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL server Event Notification for lock timeouts

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.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |