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.

    HTH

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  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.

    Bambola.
  5. satya Moderator

    Also refer the DBJournal article which will help you.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page