question

MSProg-4478 avatar image
1 Vote"
MSProg-4478 asked AlbertoMorillo answered

Azure SQL Managed instance service restart feature

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

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NavtejSaini-MSFT avatar image
2 Votes"
NavtejSaini-MSFT answered

@MSProg-4478

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MSProg-4478

Please let us know if you need any further help.

Regards
Navtej S

0 Votes 0 ·
AlbertoMorillo avatar image
1 Vote"
AlbertoMorillo answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.