Enhancement: Regex Filter on Deadlock Alert Configuration
SQL.Dave
Posts: 7
It would be helpful to filter deadlock alerts with regular expressions, in the same way RegEx can be used to filter long-running query alerts.
We have several third-party apps (which shall remain nameless) that run processes that, depending on timing, create deadlocks with other processes from the same applications. For obvious reasons, I'd like to keep deadlock alerts enabled for the servers on which the databases reside. It would also be really nice to filter out the recurring -- and really annoying -- deadlock alerts from the usual suspects.
We have several third-party apps (which shall remain nameless) that run processes that, depending on timing, create deadlocks with other processes from the same applications. For obvious reasons, I'd like to keep deadlock alerts enabled for the servers on which the databases reside. It would also be really nice to filter out the recurring -- and really annoying -- deadlock alerts from the usual suspects.
Comments
I've raised an enhancement request for this (ref: SRP-3285) to be considered for future versions.
Thanks for the feedback
Chris
Test Engineer
Red Gate
I'm finding those alerts annoying, so I've ended up having to disable them entirely (at the server scope) because there are commonly run queries executed from jobs that typically take a long time to complete.
I'm looking for exceptions to normal activity, and the way it works now isn't quite cutting it.
Have you tried setting a regEx filter for the Long-Running Query alerts?
If you check the relevant alert settings page, we do allow users to set a filter based on either SQL process name or a SQL statement.
Regards
Chris
Test Engineer
Red Gate
Oops, I guess I didn't see that before!
Thanks Chris.
Thanks for your feedback. I’ve added this to the existing enhancement request (SRP-3285) on adding RegEx filtering to deadlock alerts.
Apologies if I’ve misunderstood your additional comments, but did you know that it is possible to configure the six database-specific alerts at the database level? Once the database is selected from the Monitored servers list, the alert types relevant to that object are listed and can be customized accordingly. We’ve documented this under Configuring alert settings in the Customizing alerts help topic: http://www.red-gate.com/supportcenter/Content?p=SQL%20Monitor&c=SQL_Monitor/help/2.2/SM_CustomizingAlerts.htm&toc=SQL_Monitor/help/2.2/toc1402820.htm.
Regards,
Catherine
Yes, I knew about the database specific alerts. The problem is that deadlocks are not database specific. So, filtering is a must. Thanks for the quick response.
Joe