Azure SQL Managed instance service restart feature

Question

Hi,
In our on-prem SQL server , our support team sometimes do a service restart to freeup resource contentions, deadlocks in our dev environment.
Typically this is done, going into SSMS, right click on the instance and say Stop , then Start

Now we are exploring migrating this dev on-prem to the Azure SQL Managed instance.

the question arose: with Azure SQL MI do our support team have this option of service start/stop at all from SSMS/Portal ?
I tried in one of our MI instance but the options appear grayed out in SSMS. I am wondering this is perhaps because of my priviledges.

Please assist.

thanks

Answer 1

@MS Prog

Currently you cannot restart the Azure SQL Server. The issue has been discussed here in detail.

You can also raise a feedback on our feedback channel here.

Regards
Navtej S

Answer 2

Scaling the instance sometimes (or perhaps always) restarts. If that doesn't work, moving between Gen4 and Gen5, or between Business Critical and Standard will always require a restart as the hardware is different between Gen4 and Gen5, and the storage is different between Business Critical and Standard.

In summary, scaling up and down the instance should do the trick for you.

Answer 3

Now Stopping and starting of Azure SQL Managed Instance is available in preview.

You can find the complete information in below document.

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-stop-start-how-to?view=azuresql-mi&tabs=azure-portal

You can also Manage a stop and start schedule.

Thank you!