SQL Server Performance

SQL server Event Notification for lock timeouts

Discussion in 'Getting Started' started by Chuksie, Mar 15, 2010.

  1. Chuksie New Member

    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
  2. satya Moderator

Share This Page