How to set multiple maintenance windows
miamikk
Posts: 4 Bronze 2
We are running SQL Monitor 8 and I don't see any options to set multiple maintenance windows for a host. We got Server which are shutdown in the evenings and all thru weekends so I would like setup a one maintenance window for weekdays from 6:00 pm - 8am and second maintenance window for weekends from 12:00 am to 11:59 pm.
Can you confirm if there is a way to configure multipole maintenance windows ?
Can you confirm if there is a way to configure multipole maintenance windows ?
Tagged:
Answers
Hi @miamikk
Thank you for reaching out on the Redgate Forums regarding your SQL Monitor question.
I've reviewed the patch notes and can see that functionality for maintenance windows was improved in major release 9 - specifically version v9.2.13.
They were renamed from Maintenance Windows to Alert Suppression Windows to allow a larger scope of their usage
This functionality has grown through the major releases, these are some links from it's change in V9 through to our current major release V12
v9 docs : https://documentation.red-gate.com/sm9/configuring-sql-monitor/suppressing-alerts
v12 docs: https://documentation.red-gate.com/sm/metrics-alerts-and-notifications/configuring-alerts/suppressing-alerts
I was unable to track a product serial against your profile so am unsure if you are eligible for upgrades past major release V8. If you do have a serial # are you able to share it so we can look further.
You can log a ticket through https://productsupport.red-gate.com/hc/en-us or support@red-gate.com if you prefer not to disclose over the forum.
Download links:
V9.2.13 - change of Alert Suppression Windows
https://download.red-gate.com/checkforupdates/SQLMonitorWeb/SQLMonitorWeb_9.2.13.25553.exe
V12.1.16 - our most current version
https://download.red-gate.com/checkforupdates/SQLMonitorWeb/SQLMonitorWeb_12.1.16.27322.exe
I will have our infrastructure team to contact Redgate support team with Serail# to check on the upgrade eligibility and requirements etc.