Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    South Africa
    Posts
    9

    Red face Unanswered: Alert for DEADLOCK??

    We have a database running with about 40 users per branch (6 branches). The replication we are running at the moment (MERGE) often causes our systems to deadlock, upon which the only way to fix it is to kill the BLOCKING process.

    I would like to set up an alert that can notify me when a deadlock occurs, but so far the only success i have is on a normal lock - which occus hundreds of times per second.

    If anyone can help me out it will be of great help. My e-mail address is it@bex.co.za

    Thanx,
    Neil

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Arrow Re: Alert for DEADLOCK??

    RE:
    We have a database running with about 40 users per branch (6 branches). The replication we are running at the moment (MERGE) often causes our systems to deadlock, upon which the only way to fix it is to kill the BLOCKING process.

    I would like to set up an alert that can notify me when a deadlock occurs, but so far the only success i have is on a normal lock - which occus hundreds of times per second.

    If anyone can help me out it will be of great help. My e-mail address is it@bex.co.za

    Thanx,
    Neil
    From EM:
    (Expand out to Alerts)
    Sql Server Instance:
    Management:
    Alerts:

    (right click Alerts, select)--> New Alert:
    Name: [Deadlocks/sec]
    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)--> rises above
    Value: [0]

Posting Permissions

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