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 RothigAdminDaniel Rothig (Product Manager for SQL Monitor, Red Gate Software) 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...
      • AbhiAbhi commented  ·   ·  Flag as inappropriate

        I'm on SM v5.1.1.3239 and I don't yet see the new options for configuring maintenance times for individual alerts. Any word on when this might be released?

      • Luis MartinLuis Martin commented  ·   ·  Flag as inappropriate

        Do you have any plan to build a new version with most of suggestions during this year?. Competitions are realising new monitors like DPA 9.1, etc.
        Just a thought.

        Best regards,

      • Colin MillerchipAdminColin Millerchip (Admin, Red Gate Software) commented  ·   ·  Flag as inappropriate

        Hi Luis,

        We've been really busy recently adding support for SQL Server 2014 to all of our tools (including SQL Monitor). There's a big push on this for a couple more months, and then we'll be turning our attention again to other activities, including further SQL Monitor development.

        Thanks for bearing with us on this - as per Daniel Rothig’s comment in another UserVoice thread ( https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/2005299-allow-emails-to-be-sent-based-upon-alert-priority ), email suppression is a high priority but it's trickier than you might expect from such a seemingly straightforward feature.

        Best regards,

        Colin.

      • Luis MartinLuis Martin commented  ·   ·  Flag as inappropriate

        Hi Priya!
        Any news about this suggestion or VMware?.
        What I see is a big effort from Red Gate to Developers tools. What about SQL Monitor?
        Cheers,

      • AdamAdminAdam (User Experience Specialist, Red Gate Software) commented  ·   ·  Flag as inappropriate

        Hi Chris,

        Thanks for your suggestion. Currently, the highest voted suggestion is to supress alerts at certain times (http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/1943339-supress-alerts-based-on-time-of-day) - I'd be interested to know if that would go some way towards solving your problem, or is it important to have the configurability you suggest? Any further details will be gratefully received.

        Thanks
        Adam

      • brendo bongersbrendo bongers commented  ·   ·  Flag as inappropriate

        This seems be a old requirement but still valid.

        Currently it's still not possible to disable specific alerts during heavy resource operations - index rebuilds, backups etc(maintenance window).

      • Chris (Tech Support)Chris (Tech Support) commented  ·   ·  Flag as inappropriate

        I'm already modifying the threshold settings, however, because of different workloads at different times, it would nice to have control over the time of day that a threshold applies.

        For instance during the day serverA might be doing transaction log backups in 30 seconds, and at night when we run heavy ETL workloads serverA might take 5 minutes for the logs to finish.

        This control of the threshold values according to the time of day would avoid unnecessary alerts.

      • Rob SmithRob Smith commented  ·   ·  Flag as inappropriate

        Or, more generally, a schedule for when alert conditions do and don't apply. So I don't care about the long running query at 6 a.m. when my start of day job runs but do want to know if this condition arises between 9 to 5.

      • Johan NilssonJohan Nilsson commented  ·   ·  Flag as inappropriate

        I have some jobs that runs during the maintenance window and I would really like to know if these jobs fails even if they fail during the maintenance window

      • james esterlyjames esterly commented  ·   ·  Flag as inappropriate

        I agree with Mike's commment on needing a toggle to put the server in maintenance mode for periodic maintenance.

      • ClaudeClaude commented  ·   ·  Flag as inappropriate

        I was going to suggest the same thing as Sebastien Piche. In a DW scenario this would be very useful.

      • Mike FalMike Fal commented  ·   ·  Flag as inappropriate

        I'd also like to see a toggle added where a server can be placed into and out of maintenance mode, so that adhoc maintenance will not cause alert messages.

      • Dave GreenDave Green commented  ·   ·  Flag as inappropriate

        I find maintenance windows very useful, but not sufficiently granular. I think it would be useful if these were configurable by database and/or by alert. This allows you to ignore certain processes without impacting your monitoring of other events.

      • AdamAdam commented  ·   ·  Flag as inappropriate

        These are great suggestions for improving the configurability of the Maintenance Window feature. We've raised them as enhancements and will keep you posted on any progress.

        Again, thanks for the feedback and thanks Andrew for suggesting we merge these ideas

      ← Previous 1

      Feedback and Knowledge Base