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
• 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!
We released an improvement in 5.0 .7 so that SQL Monitor now only suspends performance-related and custom alerts during maintenance windows. All other alerts continue to be raised as normal.
We plan to review the solution of allowing configuration of maintenance times for individual alerts and will update accordingly.
I'm on SM v18.104.22.16839 and I don't yet see the new options for configuring maintenance times for individual alerts. Any word on when this might be released?
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.
Any news about SQL Monitoring?.
Fabricio Lima commented
We have some feedback about this improvement?
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.
Any news about this suggestion or VMware?.
What I see is a big effort from Red Gate to Developers tools. What about SQL Monitor?
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.
brendo bongers commented
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) commented
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.
Any update? This feature would be extremely helpful.
Thanks Johan and Rob for your suggestions.
Rob Smith commented
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 Nilsson commented
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 esterly commented
I agree with Mike's commment on needing a toggle to put the server in maintenance mode for periodic maintenance.
Thanks to you both for your feedback.
I was going to suggest the same thing as Sebastien Piche. In a DW scenario this would be very useful.
Mike Fal commented
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.
Thanks Dave for your comments. This has been requested by other users also. We hope to implement this in one of the releases on Monitor.
Dave Green commented
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.
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