{"id":1650,"date":"2019-07-18T10:36:08","date_gmt":"2019-07-18T17:36:08","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1650"},"modified":"2026-07-08T08:19:09","modified_gmt":"2026-07-08T15:19:09","slug":"diagnostic-information-queries-for-sql-managed-instance","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/diagnostic-information-queries-for-sql-managed-instance\/","title":{"rendered":"Diagnostic Information Queries for SQL Managed Instance"},"content":{"rendered":"<p>I\u2019ve put together an initial set of <a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/category\/dmv-queries\/\">Diagnostic Information Queries<\/a> for <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/sql-database\/sql-database-managed-instance-index\">SQL Managed Instance<\/a>. These were originally based on my SQL Server 2019 Diagnostic Information Queries, with any non-functional or non-relevant queries removed. I\u2019ve removed most of the non-relevant columns from the existing queries, and I have removed most of the non-relevant comments and links. <\/p>\n<p>I am still working on adding new managed instance-specific queries to the set.<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/07\/\\Lkey-features.png\"><img fetchpriority=\"high\" decoding=\"async\" title=\"key-features\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"key-features\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/07\/\\Lkey-features_thumb.png\" width=\"644\" height=\"358\"><\/a><\/p>\n<p><font style=\"background-color: #ffff00\">You can get these queries and the matching results spreadsheet from the links below:<\/font><\/p>\n<blockquote>\n<p><font color=\"#555555\"><a href=\"https:\/\/www.dropbox.com\/s\/604xg2jilu81u6y\/SQL%20Managed%20Instance%20Diagnostic%20Information%20Queries.sql?dl=0\">SQL Managed Instance Diagnostic Information Queries<\/a><\/font><\/p>\n<p><font color=\"#555555\"><a href=\"https:\/\/www.dropbox.com\/s\/f6kx7it73rfildk\/SQL%20Server%20Managed%20Instance%20Diagnostic%20Results.xlsx?dl=0\">SQL Managed Instance Diagnostic Results<\/a><\/font><\/p>\n<\/blockquote>\n<p>&nbsp;<\/p>\n<p>I\u2019ll be adding these to my <a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-diagnostic-information-queries-for-july-2019\/\">monthly update blog post<\/a> where I have all of the other diagnostic information queries. As always, please send me any feedback that you have about these. Thanks!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I\u2019ve 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\u2019ve removed most of the non-relevant columns from the existing queries, and I have removed most of the non-relevant comments and links. [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[176,445],"tags":[228,340,446],"class_list":["post-1650","post","type-post","status-publish","format-standard","hentry","category-dmv-queries","category-sql-managed-instance","tag-dmv-diagnostic-queries","tag-dmv-queries","tag-sql-managed-instance"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1650","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=1650"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1650\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}