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:
Any help, feedback or suggestions (where to find the answer) would be greatly appreciated.
Just say No to Facebook!