How to restart an Azure SQL Database Managed Instance.

Date created: April 11, 2021.

Updated: September 22, 2023.
 

What is needed?

On SQL Server instances you can use SQL Server Configuration Manager or SQL Server Management Studio to restart the database engine service. This applies to SQL Server instances on premises or installed on an Azure VM (IaaS).

For Azure SQL Database Managed Instances (PaaS) starting November 2022 there is a new feature introduced that allows to start and stop you Azure SQL Managed Instance at your discretion, to allow you save on billing costs and licensing. The new feature is part of what is called the November 2022 Feature Wave.
 

Is this feature available for all Azure SQL Managed Instances at this time?

The answer is no. Initially, only the Azure Dev/Test offers and subscriptions that are designated for Dev/Test workloads are enabled for the November 2022 Feature Wave.

Supported offer types include:

-    Enterprise Dev/Test (MS-AZR-0148P)
-    Pay-As-You-Go Dev/Test (MS-AZR-0023P)
-    Visual Studio Test Professional Credit (MS-AZR-0060P) (*)
-    Other Offer IDs that are eligible for DevTest workload types

(*) Customers using MS-AZR-0060P may not have regional quota by default, if that's the case, customers should Request a quota increase.

You can check the offer type for your subscription on Azure Portal on the subscription page.

The support for other types of subscriptions, including subscriptions designated for Production workloads, will become available over the course of the next several months. Unsupported subscription types cannot be enabled individually.

To know more about the November 2022 Feature Wave, please visit this Microsoft blog post.

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.