In SQL Monitor, I want to...

Suppress performance-related alerts during maintenance periods

CONTEXT: I expect my system to slow down during routine maintenance tasks, which often leads to false postitives for performance-related alerts (long-running queries, High CPU...) in SQL Monitor.

PROBLEM: While I could configure a maintenance window where alerts don't get raised, this would also suppress operational alerts (e.g. Machine unreachable, Job failed) - these are still relevant while maintenance is in progress

EXAMPLE SOLUTIONS:
• Allow to configure maintenance times for individual alerts
• Change maintenance window behaviour so that operational alerts are still active during maintenance

What do you think about these solutions? Got another idea? Let us know in the comments!

212 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…)
    Daniel RothigDaniel Rothig shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Chris (Tech Support)Chris (Tech Support) shared a merged idea: Dynamic alert thresholds  ·   · 
    Johan NilssonJohan Nilsson shared a merged idea: I would like to enable certain alerts during maintenance windows (i.e failed jobs)  ·   · 
    Dave GreenDave Green shared a merged idea: Allow configuration of a maintenance window per database / alert  ·   · 
    Bhairav PatelBhairav Patel shared a merged idea: Supress alerts based on time of day  ·   · 

    24 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...
      ← Previous 1

      Feedback and Knowledge Base