Support for regular expressions
Most of the alarms need more granular support for excluding/including different things. Using regular expression is a good idea and should be extended further. For example you defenitly need to be able to filter out things from the alarm on the sql server errorlog. Without it's useless.
Thanks for this suggestion, and for the supporting comments.
Several alerts now allow you to enter regular expressions to match text you want to ignore, to stop alerts being raised in certain situations.
- Deadlock (XE) alerts can be filtered by database, login name & resource (added in version 8.0.22 released November 13th 2018)
- Blocking Process alert can be filtered to exclude queries with a SQL process names, SQL commands or objects match regular expressions
- Job Duration Unusual alerts can exclude jobs matching regular expressions
- Long Running Query alerts can be filtered to exclude queries with a SQL process names, SQL commands or objects match regular expressions
We will mark this suggestion as completed, so that the votes can be returned while we continue to look at ways to make alerting more useful. Please make new suggestions for specific improvements you would like to see, and add any context that will help us understand what you are ultimately trying to do.
SQL Monitor Development Team
Tom Horner, SQL production DBA commented
I was asked to add to this item. I asked support: Is there any way to configure the “job duration unusual” alert to ignore certain jobs? In my case, I would like to ignore the transaction log backups SQL Agent jobs. Another alert allows one to ignore certain jobs, the “long running query” alert. Is there a way to do this for “job duration unusual” alert? I hope this planned change covers regular expressions for "job duration unusual" alerts also. Sometimes you have jobs that run long or slow compared to the average, but this is expected behavior and an alert is not necessary.
This would save on numberouse unncecessary high errors, most needed.
Priya Sinha commented
Thanks a lot Michael for your feedback!