Cost saving in Azure SQL Managed Instance.

We have the option to stop the Azure SQL Managed Instance when it is not in use. Like Azure SQL database which will go to pause state automatically as explained in previous article Azure SQL MI cannot go to pause or stop state automatically, we need to manually Stop/Start it.

Either we need to manually stop the Azure SQL MI instance from azure portal or by executing command. A way to automate this is to schedule the Stop and Stop activity using azure portal Under 'Settings' of Azure SQL MI there is an option 'Start/Stop Schedule'.

Stopping the Azure SQL MI instance will save the vCore and SQL License costs only data and backup storage cost will continue.

If the Azure SQL MI is part of Failover group then such instance cannot be stopped.

#azure #azuresql #azuresqlmi