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!
Daniel Rothig
shared this idea
Thanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Please see What’s New in SQL Monitor 10 for more details (https://www.red-gate.com/hub/product-learning/sql-monitor/whats-new-in-sql-monitor-10).
We hope this meets requirements and will mark it as completed. Please raise further suggestions for any improvements you would like to see.
Thanks,
SQL Monitor product team
-
Andrew Hodge
commented
Is this the same as being able to configure the maintenance window (suggestion 2) to monitor only certain alerts?
-
Bhairav Patel
commented
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 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.