Red Gate forums :: View topic - Enhancement: Regex Filter on Deadlock Alert Configuration
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

Enhancement: Regex Filter on Deadlock Alert Configuration

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
SQL.Dave



Joined: 14 Jan 2011
Posts: 4

PostPosted: Fri Jan 28, 2011 5:50 pm    Post subject: Enhancement: Regex Filter on Deadlock Alert Configuration Reply with quote

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.
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Tue Feb 01, 2011 4:08 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
clyon



Joined: 15 Feb 2011
Posts: 2

PostPosted: Tue Feb 15, 2011 3:23 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Tue Feb 15, 2011 3:31 pm    Post subject: Re: Reply with quote

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
Back to top
View user's profile Send private message
clyon



Joined: 15 Feb 2011
Posts: 2

PostPosted: Tue Feb 15, 2011 3:44 pm    Post subject: Re: Reply with quote

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.
Back to top
View user's profile Send private message
joejf



Joined: 11 Nov 2010
Posts: 8

PostPosted: Thu Apr 14, 2011 3:21 pm    Post subject: Reply with quote

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!
Back to top
View user's profile Send private message
Catherine Kearns



Joined: 14 Apr 2011
Posts: 1
Location: Red Gate Software

PostPosted: Thu Apr 14, 2011 4:53 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
joejf



Joined: 11 Nov 2010
Posts: 8

PostPosted: Thu Apr 14, 2011 5:26 pm    Post subject: Re: Reply with quote

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
Back to top
View user's profile Send private message
mschier



Joined: 13 Jan 2014
Posts: 4

PostPosted: Mon Mar 17, 2014 2:27 pm    Post subject: Reply with quote

What is the current state?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group