Enhancement: Regex Filter on Deadlock Alert Configuration

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Enhancement: Regex Filter on Deadlock Alert Configuration

Postby SQL.Dave » Fri Jan 28, 2011 5:50 pm

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.
SQL.Dave
 
Posts: 4
Joined: Fri Jan 14, 2011 7:37 pm

Postby Chris Spencer » Tue Feb 01, 2011 4:08 pm

Hi

I've raised an enhancement request for this (ref: SRP-3285) to be considered for future versions.

Thanks for the feedback
Chris
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Postby clyon » Tue Feb 15, 2011 3:23 pm

RegEx filtering would be something extremely useful, especially with Long-Running Query alerts.

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.
clyon
 
Posts: 2
Joined: Tue Feb 15, 2011 3:11 pm

Re:

Postby Chris Spencer » Tue Feb 15, 2011 3:31 pm

clyon wrote:RegEx filtering would be something extremely useful, especially with Long-Running Query alerts


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
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Re:

Postby clyon » Tue Feb 15, 2011 3:44 pm

Chris Spencer wrote:
clyon wrote:RegEx filtering would be something extremely useful, especially with Long-Running Query alerts


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


Oops, I guess I didn't see that before!
Thanks Chris.
clyon
 
Posts: 2
Joined: Tue Feb 15, 2011 3:11 pm

Postby joejf » Thu Apr 14, 2011 3:21 pm

I just want to support the enhancement request for filtering of deadlock alerts. We also have 3rd party applications that encounter a lot of deadlocks. The databases for these 3rd party applications run on our production SQL Server, which also houses our in house SQL development. I need to be able to get alerts on deadlocks occurring in our own applications and not have them lost in all of the deadlocks from 3rd party applications. One of the things I was really looking forward to in SQL Monitor was the ability to configure alerts on a database level. It makes sense that deadlocks are reported at an instance level. So, filtering is a must have!
joejf
 
Posts: 8
Joined: Thu Nov 11, 2010 4:11 pm

Postby Catherine Kearns » Thu Apr 14, 2011 4:53 pm

Hi,

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
Catherine Kearns
 
Posts: 1
Joined: Thu Apr 14, 2011 4:34 pm
Location: Red Gate Software

Re:

Postby joejf » Thu Apr 14, 2011 5:26 pm

Catherine Kearns wrote: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?


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
joejf
 
Posts: 8
Joined: Thu Nov 11, 2010 4:11 pm

Postby mschier » Mon Mar 17, 2014 2:27 pm

What is the current state?
mschier
 
Posts: 4
Joined: Mon Jan 13, 2014 11:22 am


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests