We are excited to announce the preview release of maintenance windows for Azure SQL Database and Azure SQL Managed Instance. Additional control and transparency into monthly maintenance events have been a common feedback from customers of Azure SQL Database and Managed Instance. With the preview release of maintenance windows, you can now choose from predefined time slots for maintenance and set up alerts to be notified of upcoming maintenance events.
Gain more predictability with maintenance windows
By default, all Azure SQL databases and managed instances are updated only during 5PM to 8AM local times daily to avoid any potential peak business hours interruptions. During an Azure SQL maintenance event, databases are fully available but can be subject to short failover within availability SLA as resource reconfigurations are required in some cases.
You can further adjust the planned maintenance events to a time suitable to your Azure SQL resource by choosing from two additional SQL maintenance window options.
Weekday window, 10PM to 6AM local time Monday – Thursday
Weekend window, 10PM to 6AM local time Friday - Sunday
Once the maintenance window selection is made, all planned maintenance events will only occur during the window of your choice.
Enable SQL maintenance windows on newly created and existing Azure SQL resources
Maintenance window can be set up for newly created as well as existing Azure SQL resources using the Azure portal, CLI and PowerShell. More information on how to set up maintenance windows can be found here.
Enable alerts on planned maintenance events via advance notification
Alerts can be configured for Azure SQL Database to notify customers on upcoming planned maintenance events 24 hours in advance. More information on how to set up advance notification can be found here.
What is the pricing and eligibility for SQL maintenance windows?
The Azure SQL maintenance window and maintenance alerts are available and free of charge for the following subscription offer types: Pay-As-You-Go, Cloud Solution Provider (CSP), Microsoft Enterprise, or Microsoft Customer Agreement.
Some limitations apply
The Hyperscale service tier is not currently supported on Azure SQL maintenance window but planned later in 2021.
Additional exclusions include Gen4 vCore general purpose & business critical offers; Basic, S0, S1 offers; M-series, FsV2-series, DC-series hardware offers.
Azure SQL Managed Instance maintenance alerts are not currently supported but planned later in 2021.
Available regions for preview
The SQL maintenance window preview is available in a number of supported regionswith more Azure regions planned over the remainder of the year.