Dynamic alert thresholds
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.
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.