Azure SQL Managed instance - Change the Service Tier from Business Critical to General Purpose

Question

Hello,

I would like to know if it is possible to change the service tier of an Azure SQL managed instance from "Business Critical" to "General Purpose" (it seems to be possible through the Azure portal) and what impact it has on the service availability (interruption, downtime)?

Thank you in advance for your answers.

Answer 1

Hi,

Here is a quote from one of the MI team:

The upgrade from the standard-series SQL MI to one of the premium-series offers (and back, if needed) is easy to do. It’s a executed as a standard Azure SQL instance scaling operation (similar to changing the number of vCores or reserved storage size for the instance) -> it’s a fully managed, online, async workflow (customer can continue to use their instances while the operation is being performed).

And for full answer you can check this doc:

https://learn.microsoft.com/en-us/azure/azure-sql/database/scale-resources?view=azuresql&WT.mc_id=DP-MVP-5001699

So the short answer is that it is possible and you can continue working on the database while doing so. Check the document for more info before you start