Relative-day maintenance windows
Rackspace maintenance days revolve around, for example, "Default week - Wednesday - 02:00 to 04:00", where "default week" is established in the service contract. That can change to early-week or (I forget the name) "late-week".
Current SQL Monitor Maintenance Windows are wholly inadequate to record a "Default week is 2nd week of each month, maintenance on that week's Wednesday, at (the time period)".
Without this, my PagerDuty Alerts go berserk during maintenance windows, and shy of having someone go and suspend monitoring at 2 in the morning and remember to turn it back on, it just keeps on sending out unwanted alerts.
As Red Gate uses, or at least used to use, RS, would this be in our mutual interest to support this kind of window scheduling?
And then there is OUR maintenance day, which falls on a NON-RS week, at a different time! So we need TWO maintenance windows PER SERVER, that are BOTH relative-week-and-day centric.
I've up-voted the "need two windows" suggestion, but this goes beyond that need.
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
Stefan LK commented
I could not agree more. Just a regular Microsoft patch Tuesday + weekly maintenance weekend could not be that uncommon, right?