{"id":1115,"date":"2017-03-12T21:32:46","date_gmt":"2017-03-12T16:02:46","guid":{"rendered":"http:\/\/pramodsingla.com\/?p=1115"},"modified":"2017-03-12T21:32:46","modified_gmt":"2017-03-12T16:02:46","slug":"find-slow-running-queries-using-the-reports-in-ssms","status":"publish","type":"post","link":"https:\/\/pramodsingla.com\/?p=1115","title":{"rendered":"SQL Server Tuning: Find Slow running queries using the Reports in SSMS"},"content":{"rendered":"<div align=\"center\">\n<h2><strong>Find Slow running queries using the Reports in SSMS<\/strong><\/h2>\n<\/div>\n<h2><strong>1) High CPU consuming Queries:<\/strong> To run the report right click the server name in SSMS&gt;reports&gt;standard Reports&gt;performance \u2013Top queries by average Time<\/h2>\n<div align=\"center\">\n<p><a href=\"https:\/\/pramodsingla.files.wordpress.com\/2017\/03\/1.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-large wp-image-1117\" src=\"https:\/\/pramodsingla.files.wordpress.com\/2017\/03\/1.jpg?w=1024\" alt=\"\" width=\"1024\" height=\"546\" srcset=\"https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/1.jpg 1133w, https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/1-300x160.jpg 300w, https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/1-1024x546.jpg 1024w, https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/1-768x409.jpg 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<h2><strong>Figure 1:<\/strong> How to get to the performance reports<\/h2>\n<\/div>\n<div align=\"center\">\n<p><a href=\"https:\/\/pramodsingla.files.wordpress.com\/2017\/03\/2.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1118\" src=\"https:\/\/pramodsingla.files.wordpress.com\/2017\/03\/2.jpg\" alt=\"\" width=\"773\" height=\"427\" srcset=\"https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/2.jpg 773w, https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/2-300x166.jpg 300w, https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/2-768x424.jpg 768w\" sizes=\"(max-width: 773px) 100vw, 773px\" \/><\/a><\/p>\n<h2><strong>Figure 2:<\/strong>\u00a0 Top 10 queries by CPU time<\/h2>\n<\/div>\n<h2><strong>2) Queries with highest IO:<\/strong> To run the report right click the server name in SSMS&gt;reports&gt;standard Reports&gt;performance \u2013Top queries by average IO<\/h2>\n<div align=\"center\"><a href=\"https:\/\/pramodsingla.files.wordpress.com\/2017\/03\/3.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1119\" src=\"https:\/\/pramodsingla.files.wordpress.com\/2017\/03\/3.jpg\" alt=\"\" width=\"849\" height=\"562\" srcset=\"https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/3.jpg 849w, https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/3-300x199.jpg 300w, https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/3-768x508.jpg 768w\" sizes=\"(max-width: 849px) 100vw, 849px\" \/><\/a><br \/>\n<strong>Figure 3:<\/strong> Top 10 quries by IO<\/div>\n<h2><strong>3) Server Dashboard:<\/strong> To run the report right click the server name in SSMS&gt;reports&gt;standard Reports&gt;Server Dashboard<\/h2>\n<div align=\"center\">\n<h2><a href=\"https:\/\/pramodsingla.files.wordpress.com\/2017\/03\/4.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1116\" src=\"https:\/\/pramodsingla.files.wordpress.com\/2017\/03\/4.jpg\" alt=\"\" width=\"859\" height=\"532\" srcset=\"https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/4.jpg 859w, https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/4-300x186.jpg 300w, https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/4-768x476.jpg 768w\" sizes=\"(max-width: 859px) 100vw, 859px\" \/><\/a><br \/>\n<strong>Figure 4:<\/strong> Server Dashboard<\/h2>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Find Slow running queries using the Reports in SSMS 1) High CPU consuming Queries: To run the report right click[&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[23],"tags":[66,112,125,151],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/1115"}],"collection":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1115"}],"version-history":[{"count":0,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/1115\/revisions"}],"wp:attachment":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}