I’ve put together an initial set of Diagnostic Information Queries for SQL Managed Instance. These were originally based on my SQL Server 2019 Diagnostic Information Queries, with any non-functional or non-relevant queries removed. I’ve removed most of the non-relevant columns from the existing queries, and I have removed most of the non-relevant comments and links.

I am still working on adding new managed instance-specific queries to the set.

key-features

You can get these queries and the matching results spreadsheet from the links below:

SQL Managed Instance Diagnostic Information Queries

SQL Managed Instance Diagnostic Results

 

I’ll be adding these to my monthly update blog post where I have all of the other diagnostic information queries. As always, please send me any feedback that you have about these. Thanks!