Blog Post

Azure SQL Blog
2 MIN READ

Announcing GA of Advance Maintenance Notifications for Azure SQL Database

scott_kim's avatar
scott_kim
Icon for Microsoft rankMicrosoft
Mar 27, 2024

 

We are pleased to announce the GA release of Advance Maintenance Notification for Azure SQL Databases. 

 

 

What is advance maintenance notifications?

Working along-side SQL Maintenance Windows, Advance planned notifications feature allows you to prepare for planned maintenance events on your Azure SQL Database resources by alerting  you 24 hours before the planned maintenance events which can help you minimize the impact on your sensitive workloads.

 

How does advance maintenance notifications work?

These notifications are integrated with Service Health's planned maintenance experience and allow you to view all scheduled maintenance for your subscriptions in one place. It also helps to scale the notification to the right audiences for different resource groups, as you may have different contacts responsible for different resources. You will receive the notifications about the upcoming maintenance 24 calendar hours before the maintenance event; as the maintenance event starts and as the maintenance event completes.

These notifications support a variety of alerting options including email, SMS, Azure app push notification and the additional actions to be triggered (Azure Function, Logic App, Webhook, etc.). 

 

How do you set up advance planned notifications?

Setting up advance notifications is simple as described here:

  1. Go to the Service Health Planned maintenance page, select Health alerts, then Add service health alert.

 

  1. In the Scope section, select subscription.

  1. In the Condition section, configure service(s) to be alerted for, region(s) and criteria. For more generic alert, select all values. To narrow down, select Azure SQL Database as a service, region(s) where you have those services deployed, and Planned maintenance for the event type.

 

 

  1. In the Actions section, select the existing action group or create a new one.

  1. In the Details section, define the name for your alert and specify resource group where it should be deployed.

  1. Select Review + create. Your alert is created.
  2. You're all set. Next time there's a planned Azure SQL maintenance event, you'll receive an advance notification.

 

To learn more, please visit 

https://aka.ms/SQLAdvNotification   

 

 

Updated Mar 27, 2024
Version 1.0
  • hayriozler's avatar
    hayriozler
    Copper Contributor

    This is very useful, but why 24 hours before, sometimes we have a bank holiday that can be than more 24 hours, in this case, we may miss the information.

  • albertozgz's avatar
    albertozgz
    Copper Contributor

    Hello, 
    (Agree with the first comment, 24 hours is not very realistic)

     

    Sounds reasonable expose this Info on Az Resource Graph 

    Use Case: We have PBI + KQL Admin dashboards, add this info "Next Maintenance Scheduler" would be so handy