Exclude specific deadlocks via Hostname or Application

JimRound

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

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.

JimRound

Thanks for the detailed response, I will certainly raise this as a suggestion, thanks again for the clarification.