Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2007

    Unanswered: SS Agent Alerts - Deadlock Event detection

    I have setup the following in an attempt to trace deadlocks on event ocurrance. I'm using SS05 / SP3 Standard 64-bit on Win 2003/R2.

    1. SS Agent alert setup on Error number: 59103 (deadlock)
    2. Response is setup to invoke a sql server trace
    3. Trace is an SS Agent job
    -- this works, been tested standalone, and traces for 1 minute, logging trace file to the file system

    I create a deadlock with test code ..
    no trace, no nothing ..

    Anyone have any idea why this doesn't capture the deadlock, or, if you have another method to capture the event, and invoke the job, I'll try that too.

    Thanks in advance.
    Last edited by stuarta; 09-22-09 at 12:24.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts