SQL Server Performance

Alert for DeadLock

Discussion in 'Performance Tuning for DBAs' started by tikus, Aug 29, 2003.

  1. tikus New Member

    I use Error 1222 to detect deadLock, unfortunately, the Alert didn't fire.

    How should I set up the Alert so that it would fire when deadlock occured? Thanks!
  2. satya Moderator

    Goto EM ---> Management --> Alerts --> right click and select new alert.
    Type: (select from dropdown)--> Sql Server Performance conditon alert
    Object: (select from dropdown)--> YourInstanceName:Locks
    Counter: (select from dropdown)--> Number of Deadlocks/sec

    Alert if counter: (select from dropdown)--> and assign value 0.

    Refer to DBjournal articlehttp://databasejournal.com/features/mssql/article.php/1498781 for more information.


    Satya SKJ
  3. tikus New Member

    Thanks Satya! Is there any other way I can use? I have tried this option before, the Alert fire almost every second due to App deadlock. However, the Trace 1204 doesn't print the error to error log. I guess App deadlock is common!!? [?]
  4. bambola New Member

    with DBCC TRACEON(3605) output will be directed to the error log.

  5. satya Moderator

    Also refer the DBJournal article which will help you.

    Satya SKJ

Share This Page