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!

199 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 →
    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  ·   · 

    21 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...
      • 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,

      • 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).

      • 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

      • Andrew HodgeAndrew Hodge commented  ·   ·  Flag as inappropriate

        Is this the same as being able to configure the maintenance window (suggestion 2) to monitor only certain alerts?

      • Bhairav PatelBhairav Patel commented  ·   ·  Flag as inappropriate

        We know that certain big batch jobs will be running that will take up extra resources at certain times of the day, what we would like to do is suppress these alerts so that we can keep our "tighter" thresholds during the day for when the system is open to the users.

      • Andrew HodgeAndrew Hodge commented  ·   ·  Flag as inappropriate

        I would like the ability for a maintenance window to filter which events are monitored. ie during a maintenance window I would still be interested in server and sql server availability but not processor utilization and long running queries

      ← Previous 1

      Feedback and Knowledge Base