In SQL Monitor, I want to...

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.

53 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Michael PetterssonMichael Pettersson shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Tom Horner, SQL production DBATom Horner, SQL production DBA commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base