2

Does anyone know how to restart a SQL Server Managed Instance?

The stop / start / reset are all grayed out, so that’s really. It an option.

Any thoughts?

Thanks...

1
  • Are you having a problem that you think an Instance restart would solve? There might be a more surgical fix, so additional background on why might help – AMtwo Jan 5 '19 at 13:41
4

You don't restart Managed Instance. The beauty of PaaS is that the cloud service provider ensures that you get a certain uptime SLA-- 99.99% in this case.

The service is abstracted away. Microsoft will ensure that the service is "always" up and running. They handle patching and maintenance on the OS and the instance (and necessary restarts that go along with those things).

If you need to stop, scale, or make other changes to the instance, you'd do that from the Azure portal (either the web GUI or PowerShell).

3
  • AMTwo, I would love to go with that answer, but the problem is that I need to reset TempDB. By default, for some reason, it was set to autogrow in 8 MB chunks. Now that it's over 1 TB in size, anything that uses tempdb is amazingly slow because of all of the VLFs. – Kevin Wilkie Jan 5 '19 at 20:42
  • And I've tried restarting from the Azure portal itself, but I either don't have permissions or it's just not there. – Kevin Wilkie Jan 5 '19 at 20:44
  • 3
    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. – David Browne - Microsoft Jan 6 '19 at 18:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.