SQL Server Managed Instance Diagnostics

The great thing about SQL Server Managed Instance (SQL MI) is that you don’t need to perform any maintenance or troubleshooting on the OS or SQL installation. In theory. If you’ve used SQL MI, you might find that this isn’t always the case. If you have issues, you’ll find that you have limited troubleshooting options on the server and your options for running scripts are constrained. Microsoft support doesn’t have unfettered access either. They have hard boundaries on what can be accessed on your servers and they need to escalate quite extensively to other internal teams when examining certain problems.