Post reply

alerts

  • March 7, 2013 at 6:54 am

    #394332

    I have alerts setup for severity numbers 016, 017, 018, 019, 020, 021, 022, 023, 024, 025, but I'm not gettting notified when a deadlock occurs (I only see 50 triggers on 016, last one on February 22). I would of thought one of these would catch the deadlock timeout?

    Is there a way to test the email function of Operators assigned to alerts?

  • March 7, 2013 at 7:16 am

    #1594435

    Usual deadlock error 'Transaction (Process ID %d) was deadlocked on %.*ls resources with another process and has been chosen as the deadlock victim. Rerun the transaction.' is severity 13.

    You can check severity levels in master.sys.messages

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply