{"id":4961,"date":"2019-02-13T11:45:24","date_gmt":"2019-02-13T19:45:24","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/paul\/?p=4961"},"modified":"2019-02-13T12:48:18","modified_gmt":"2019-02-13T20:48:18","slug":"using-the-wait-statistics-report-in-azure-data-studio","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/","title":{"rendered":"Using the Wait Statistics Report in Azure Data Studio"},"content":{"rendered":"<p style=\"text-align: justify;\">Azure Data Studio, which used to be called SQL Operations Studio, has a bunch of extensions available, including one called Server Reports from Microsoft. Last year they took my wait stats query (from here) and made it into a report\u00a0as part of Server Reports extension. In this quick post I&#8217;ll show you how to install that extension and look at the report.<\/p>\n<p style=\"text-align: justify;\">I&#8217;ve been using Azure Data Studio a lot as part of working with SQL Server 2017 on Linux in Azure and I like it a lot. It&#8217;s obviously not as comprehensive as SSMS, but for simple stuff it does the job.<\/p>\n<p style=\"text-align: justify;\">You can see the pretty big list of available extensions by hitting the Extensions icon:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/1.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-4962\" src=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/1.jpg\" alt=\"\" width=\"353\" height=\"369\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/1.jpg 353w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/1-287x300.jpg 287w\" sizes=\"(max-width: 353px) 100vw, 353px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">In the list that appears, find the Server Reports extension and click the Install button:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/2.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4963\" src=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/2.jpg\" alt=\"\" width=\"311\" height=\"67\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/2.jpg 311w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/2-300x65.jpg 300w\" sizes=\"(max-width: 311px) 100vw, 311px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Once\u00a0an extension is installed, you need to activate it. Without reading any documentation, the first time I used\u00a0Azure Data Studio I couldn&#8217;t figure out why the extension wasn&#8217;t there once I&#8217;d installed it. Click the Reload button to active the extension:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/3.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4964\" src=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/3.jpg\" alt=\"\" width=\"615\" height=\"207\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/3.jpg 615w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/3-300x101.jpg 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">The extension will now show up in the list of enabled extensions:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4965\" src=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/4.jpg\" alt=\"\" width=\"312\" height=\"94\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/4.jpg 312w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/4-300x90.jpg 300w\" sizes=\"(max-width: 312px) 100vw, 312px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">If the Server Dashboard screen isn&#8217;t showing, right-click on one of the servers you&#8217;re connected to and select Manage. All the active extensions will show as tabs at the top of the screen, so select Server Reports and then click the heart-shaped icon and you&#8217;ll see the current aggregate wait stats for the instance:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/5.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4966\" src=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/5.jpg\" alt=\"\" width=\"617\" height=\"578\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/5.jpg 617w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/5-300x281.jpg 300w\" sizes=\"(max-width: 617px) 100vw, 617px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Note that the x-axis is percentage of all waits, not wait count. You&#8217;ll see that <a href=\"https:\/\/www.sqlskills.com\/help\/waits\/preemptive_os_flushfilebuffers\/\" target=\"_blank\" rel=\"noopener noreferrer\"><em>PREEMPTIVE_OS_FLUSHFILEBUFFERS<\/em><\/a>\u00a0is the top wait on my Linux instance &#8211; that&#8217;s by design and I&#8217;ll blog about that next. I&#8217;ve also submitted a GitHub change to add that wait to the list of waits filtered out by script the extension uses.<\/p>\n<p style=\"text-align: justify;\">Anyway, you can drill in to the details by clicking the ellipsis at the top-right of the graph and\u00a0selecting &#8216;Show Details&#8217;. That&#8217;ll give all the waits and by selecting each one you can see the usual output from my waits script. To get more information on what each wait means, select the bottom cell, right-click on the URL to copy it, and paste into your favorite browser to go to my waits library. And of course, you can refresh the results via the ellipsis as well.<\/p>\n<p style=\"text-align: justify;\">There are many more useful extensions that you should check out too &#8211; enjoy!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Azure Data Studio, which used to be called SQL Operations Studio, has a bunch of extensions available, including one called Server Reports from Microsoft. Last year they took my wait stats query (from here) and made it into a report\u00a0as part of Server Reports extension. In this quick post I&#8217;ll show you how to install [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[109,114,112,101],"tags":[],"class_list":["post-4961","post","type-post","status-publish","format-standard","hentry","category-azure","category-azure-data-studio","category-linux","category-wait-stats"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using the Wait Statistics Report in Azure Data Studio - Paul S. Randal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using the Wait Statistics Report in Azure Data Studio - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"Azure Data Studio, which used to be called SQL Operations Studio, has a bunch of extensions available, including one called Server Reports from Microsoft. Last year they took my wait stats query (from here) and made it into a report\u00a0as part of Server Reports extension. In this quick post I&#8217;ll show you how to install [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-13T19:45:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-02-13T20:48:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/1.jpg\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/\",\"name\":\"Using the Wait Statistics Report in Azure Data Studio - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/1.jpg\",\"datePublished\":\"2019-02-13T19:45:24+00:00\",\"dateModified\":\"2019-02-13T20:48:18+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/1.jpg\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/1.jpg\",\"width\":353,\"height\":369},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using the Wait Statistics Report in Azure Data Studio\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using the Wait Statistics Report in Azure Data Studio - Paul S. Randal","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/","og_locale":"en_US","og_type":"article","og_title":"Using the Wait Statistics Report in Azure Data Studio - Paul S. Randal","og_description":"Azure Data Studio, which used to be called SQL Operations Studio, has a bunch of extensions available, including one called Server Reports from Microsoft. Last year they took my wait stats query (from here) and made it into a report\u00a0as part of Server Reports extension. In this quick post I&#8217;ll show you how to install [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/","og_site_name":"Paul S. Randal","article_published_time":"2019-02-13T19:45:24+00:00","article_modified_time":"2019-02-13T20:48:18+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/1.jpg","type":"","width":"","height":""}],"author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/","name":"Using the Wait Statistics Report in Azure Data Studio - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/1.jpg","datePublished":"2019-02-13T19:45:24+00:00","dateModified":"2019-02-13T20:48:18+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/1.jpg","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2019\/02\/1.jpg","width":353,"height":369},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/using-the-wait-statistics-report-in-azure-data-studio\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"Using the Wait Statistics Report in Azure Data Studio"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=4961"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4961\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=4961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=4961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=4961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}