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

Exclude specific deadlocks via Hostname or Application

Hi, 

We have an application that generates numerous deadlocks, we are aware this happens and it isn't causing us any issues, ideally we'd like to be able to filter out these alerts to reduce the level of noise. 

That being said we also don't want to just turn off alerts for deadlocks completely as we would definitely want to know if other deadlocks occurred within the system.

The only pieces of identifiable information we have, that are always consistent when viewing the deadlock screen are the hostname and application, is it possible to exclude deadlock alerts using either of these?

I've tried the following in the "Exclude deadlocks involving resources matching the following regular expressions:", without success.

MDL|MDL01|Hostname:MDL01|Application:MDL

Any help would be appreciated.

Cheers
Jim
JimRound
0

Comments

2 comments

Sort by
  • Russell D
    There's no way to filter by hostname or application I'm afraid. Resources here refers to strictly anything in the objectname property of any children of the resource-list section in the xdl. So if you take a look at this example, its it's b35961e8-4037-4c09-8235-127cd82c72ba.dbo.Employees and b35961e8-4037-4c09-8235-127cd82c72ba.dbo.Suppliers.

    Can I suggest that you post this over on     https://sqlmonitor.uservoice.com/forums/91743-suggestions? As we use this to help make decisions about future feature work.
    Russell D
    0
  • JimRound
    Thanks for the detailed response, I will certainly raise this as a suggestion, thanks again for the clarification.
    JimRound
    0

Add comment

Please sign in to leave a comment.