SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Monitor 3.x - Customizing Alerts Via Regular Expressions


SQL Monitor 3.x - Customizing Alerts Via Regular Expressions

Author
Message
YSLGuru
YSLGuru
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1814 Visits: 1665
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!
daniel.rothig
daniel.rothig
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 15
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search