PLaying around with a trial version at the moment and have got a question; we’ve a third party app that uses on DB on a multi-DB server that is written so wonderfully badly that it likes to issue deadlocks like they’re going out of fashion; As a resultI’d like to exclude Deadlock alerts from this DB only and not any of the others on the server.
Is this even possible? I’ve not seen any means of doing so in the alert configuration.
In addition, can one remove\modify alerts for different disk drives?
For the Deadlock alert in particular, there’s not currently a way to filter out particular databases (or disks) from firing the alert. That seems like a reasonable thing to try to do, though, so I’ll go ahead and pass the request on to product development to see if we might add it in a future release.
A lot of the alerts do have an “Advanced” button in the bottom right of the configuration pane, and some of these allow you to filter the alerts to include or exclude particular database, disks, and other factors. I’d look for the Advanced options for a given alert to see if the particular filter you’re looking for exists on that alert.
Hi Rachel, is there any update on this since it's been 5 years? I have a few deadlock alerts that generate constantly for some poorly written apps that I can't filter out, but we get hit by them constantly.
We gave up a long time ago and in 4 weeks time that system is being turned off, thus removing the issue entirely.