How can we help you today? How can we help you today?

Ignore specific deadlock

We have a 3rd party app that generates a lot of deadlocks (> 30/day). There's nothing we can do about this. Is there away to turn off the alerts for this SPECIFIC deadlock (always same lock details), so that we can still get alerted about others
markseg
0

Comments

5 comments

Sort by
  • markseg
    no-one? not being able to do this makes deadlock alerts useless fro us
    markseg
    0
  • amandaj
    Hi Markseg,

    Unfortunately, there isn't currently a way to ignore certain deadlocks based on a criteria.

    There is currently a Uservoice suggestion for this that you can vote and comment on:
    https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/16598887-block-specific-deadlocks-by-lock-details

    Kind regards,
    Amanda
    amandaj
    0
  • Luke L
    This is something that has been requested since v5. Now that Extended events are being used, I would assume this may be a bit easier to configure?

    there are already 2 user voice threads on it.
    https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/18464269-deadlock
    And
    https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/16598887-block-specific-deadlocks-by-lock-details

    I really don't like having to turn off deadlock events for my entire instance due to 1 poorly behaving application/database or process.

    Has there been any movement on this?
    Thanks,
    -Luke.
    Luke L
    0
  • Adam W
    Thanks for prompting us again on this. We do agree this is something we should improve and we'll try to bring this work forward. I can't say just yet when we might commit to this, but I will post an update soon when we've had the relevant discussions.

    Thanks for your patience.
    Adam
    Adam W
    0
  • Luke L
    Adam, thanks for responding. This is something that's been asked for a number of times. Even if it's not perfect something would be better than nothing. You're already grabbing the deadlocked query text and/or Object IDs so I would think it would be a matter of parsing that text for the database context and or regex strings to eliminate the alert email.

    I understand that every time something like this is done there is a cost to perform that work and balancing the reward with the Processing cost is key to the decision making process as well as balancing other user requests and product enhancements.

    I look forward to seeing this in the product in the near future.
    thanks,
    -Luke.
    Luke L
    0

Add comment

Please sign in to leave a comment.