Ignore specific deadlock

markseg

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

no-one? not being able to do this makes deadlock alerts useless fro us

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

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.

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

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.