Azure – Maintenance window is available for SQL Database and SQL Managed Instance

As you know the beauty of the PaaS is you don’t have anymore to manage the underlying infrastructure (patching OS for example) as this the responsibility of the cloud provider.

Well, while this is very interesting you lose a little bit of control, especially when it comes to maintenance.

Well, you can now manage the maintenance window for your SQL Managed Instance and SQL Database.

By default, the maintenance window is set between 5 PM and 8 AM every day (based on local time of your Azure region).

You now have the ability to define a different maintenance window between the 2 options:

  • 10:00 PM to 6:00 AM local time, Monday – Thursday
  • 10:00 PM to 6:00 AM local time, Friday – Sunday

This can be managed either during the database or managed instance creation and on existing ones.

image  image

In addition, you can also configure the alerting option – this is in preview –  (only for existing database or managed instance; this is not available during the creation) to be alerted on planned maintenance 24 hours in advance, under the Maintenance blade.

image

This option will redirect you to the Service Health\Health Alert blade; you can configure the maintenance alert by following the documentation available here https://docs.microsoft.com/en-us/azure/azure-sql/database/advance-notifications

Leave a Comment

Your email address will not be published.