Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Monitor 3.x - Customizing Alerts Via Regular Expressions Expand / Collapse
Author
Message
Posted Tuesday, October 1, 2013 1:45 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 11:19 AM
Points: 892, Visits: 1,555
In SQL Monitor you can custom the LRQ (Long Running Query) Alert to not be raised if the SQL Command/code matches a regular expression you've specified. The problem is there’s no help/info that I can find on how to use this thing. For example what form of Regular Expressions do I use? In UltraEdit you have to select between PEARL, UNIX or UltraEdits own flavor of Regular Expressions.

I've already posted this at the Red-Gate User forum over a week ago and not one reply has been made; not even by an employee and that’s odd.

On the SQL Monitor product documentation page that covers Alert Configuration there’s no mention of the Regular Expression option not even a passing reference let alone how to use it.

Does anyone one these forums have any experience using Regular Expressions in SQL Monitor Alerts and if so then what is the exact set of characters you need to specify in the regular expression to filter out any LRQ alerts that contain the below:

WAITFOR


Any help, feedback or suggestions (where to find the answer) would be greatly appreciated.

Thanks


Kindest Regards,

Just say No to Facebook!
Post #1500576
Posted Wednesday, October 2, 2013 8:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 10:09 AM
Points: 1, Visits: 13
Hi there,

Sorry we didn't spot your question in the Forums - usually we keep on top of these things. We use the Regex flavour implemented in .NET, which is documented here: http://msdn.microsoft.com/en-us/library/az24scfc(v=VS.100).aspx For more details, hit the blue "?" in the alert configuration for Long-running query alerts, which should help to get you started. Finally, the exact Regex you're looking for is:

WAITFOR

Literally just this word will exclude all queries that include "WAITFOR" in their query text.

Hope that helps,
Daniel
Post #1500794
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse