SQL Monitor 3.x - Customizing Alerts Via Regular Expressions

  • YSLGuru

    SSC-Insane

    Points: 21301

    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

    Valued Member

    Points: 55

    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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply