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
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
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.
Now Stopping and starting of Azure SQL Managed Instance is available in preview.
You can find the complete information in below document.
You can also Manage a stop and start schedule.
Thank you!