Alert Settings Long Running Query Exclude RegEx

SQL Server performance monitoring and alerting

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

Alert Settings Long Running Query Exclude RegEx

Postby wwalborn » Thu Mar 13, 2014 2:36 pm

Using: Version: 3.5.0.497

Here is an example email content for a long running query that I want to exclude (any SQLAgent jobs):

Process name: SQLAgent - TSQL JobStep (Job 0x1C32C6B680AD91468B8FB415ED990C70 : Step 6)

I have tried both of these and a few others, none of them seem to match and exclude, what am I missing?

Added to section
"Exclude queries with a SQL process name matching the following regular expressions:"

.*SQLAgent - TSQL JobStep .*

^SQLAgent.*


If are successfully filtering SQLAgent alerts, please share what is working for you. Thanks.
wwalborn
 
Posts: 3
Joined: Thu Mar 13, 2014 2:28 pm
Location: United States

Postby Brian Donahue » Fri Mar 14, 2014 5:08 pm

Hello,

The last time this issue came up, it worked to put the whole string in square-brackets like this:
[SQL Agent - TSQL JobStep]

Hopefully that does the trick.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby wwalborn » Fri Mar 14, 2014 8:11 pm

Changed to use brackets, will see what happens this weekend. Thanks.
wwalborn
 
Posts: 3
Joined: Thu Mar 13, 2014 2:28 pm
Location: United States

Postby wwalborn » Mon Mar 17, 2014 3:02 pm

Well, that did not appear to work with simply brackets, I am going to try a shotgun approach and list all of the variations that seem logical to me:

[SQLAgent]
[SQLAgent]*
[SQLAgent].*
.*[SQLAgent].*
^SQLAgent.*
^SQLAgent.*\\n
wwalborn
 
Posts: 3
Joined: Thu Mar 13, 2014 2:28 pm
Location: United States

Postby Brian Donahue » Wed Mar 19, 2014 3:47 pm

I tried it using just the text and the query was blocked. Maybe you did not set the restriction at the right server? You can configure the alerts differently for different servers. Here is what I have set currently, which is blocking long-running query alerts for all servers:
Exclude queries with a SQL process name matching the following regular expressions:
Red Gate Software - SQL Tools
SQLAgent - TSQL JobStep
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 1 guest