be able to choose the actions during maintenance window.
During a monthly patch round along the servers, a restart or some downtime is mandatory. I want to be able to select the actions SQL Monitor will perform with the alerts triggered within that maintenance window. Most of the time I'm aware of the required Windows reboot, so I do not need an email telling me that the SQL Server was not reachable for a short period. So I would like to tell SQL Monitor not to trigger any alert during the maintenance window. (preferably a one-time maintenance window, see other suggestion)
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.
SQL Monitor product team
Luke L commented
I agree maintenance windows used to silence all alerts which worked well for this type of scenario. In recent versions they are less useful. We end up having to suspend monitoring for an instance for significantly longer times that would be required if we could use Maintenance windows as they were designed previously.