Disable deadlock alert emails at the database level
We have a couple of databases from 3rd party apps that regularly deadlock themselves, typically trying to update tables that are undergoing housekeeping operations. I can't fix it so I don't really want to keep hearing about it. But I'd like the deadlocks to be recorded so I can still investigate if I get reports of serious issues.
A bump for this one. looks like it's not been looked at in a while but the issue is still a p.i.t.a!
Johnny Couture commented
Why don't make it possible to disable *any* alert at a database level... It would result in a better management, for example for 3rd party databases alerts.Thank you !
Another vote for this. I have the same issue with a 3rd party database which I know has frequent deadlocks (50+ every night) thus 'real' deadlocks get lost in their 'noise'. Disabling per server isn't an option as I would still like to be informed of deadlocks in the other databases on the same server.
This would be a really useful addition, especially where something as noisy as Reporting Services has its database hosted on a server with other databases.