Supress alerts based on time of day
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.
I need to configure an alert to fire only in work time (9am - 6pm). After this time, i don't need this alert, but i need to monitor other alerts.
This is very useful especially for this important alert "long-running query".
It can also help in some other things where the thresholds is different in work time and after the work time.
Disable specifique alert for time Range exemple long running querry is not issue during wharehouse processe but il receive log full or all other alert
I’d like greater configuration with the maintenance window feature. To suit our maintenance schedule we need to able to set it for the 2nd Saturday of every month.
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.
Luis Martin commented
Any news about this suggestion or VMware?.
What I see is a big effort from Red Gate to Developers tools. What about SQL Monitor?
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).
Any update? This feature would be extremely helpful.
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.
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 Hodge commented
Is this the same as being able to configure the maintenance window (suggestion 2) to monitor only certain alerts?
Andrew Hodge commented
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
Thanks for the feedback. We are considering adding more configurability to the maintenance window feature and this kind of use case is something we have been asked to support so will certainly consider.