Skip to content

In Redgate Monitor, I want to...

← Suggestions

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.

74 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Michael Pettersson shared this idea  ·   ·  Report…  ·  Admin →
completed  ·  Adam responded  · 

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.

For example:
- 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.

Thanks,
SQL Monitor Development Team

Show previous admin responses (2)

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Tom Horner, SQL production DBA commented  ·   ·  Report

    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.

  • Anonymous commented  ·   ·  Report

    This would save on numberouse unncecessary high errors, most needed.

Suggestions

Categories

Feedback and Knowledge Base

(thinking…)