{"id":19570,"date":"2023-08-02T06:21:22","date_gmt":"2023-08-02T10:21:22","guid":{"rendered":"https:\/\/kevinjustin.com\/blog\/?p=19570"},"modified":"2023-08-02T06:21:56","modified_gmt":"2023-08-02T10:21:56","slug":"sql-query-plan-howto-diagnose-sql-query-execution","status":"publish","type":"post","link":"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/","title":{"rendered":"SQL query Plan howto"},"content":{"rendered":"<figure id=\"attachment_19571\" aria-describedby=\"caption-attachment-19571\" style=\"width: 416px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/CantYouDoAnythingRight.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-19571\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/CantYouDoAnythingRight.jpg\" alt=\"SQL Query Plan - can't you do anything right?\" width=\"416\" height=\"325\" srcset=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/CantYouDoAnythingRight.jpg 416w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/CantYouDoAnythingRight-300x234.jpg 300w\" sizes=\"auto, (max-width: 416px) 85vw, 416px\" \/><\/a><figcaption id=\"caption-attachment-19571\" class=\"wp-caption-text\">SQL Query Plan &#8211; can&#8217;t you do anything right?<\/figcaption><\/figure>\n<p>Ever need to build out a capability and the SQL query is your blocker?\u00a0 Use a SQL query Plan &#8216;howTo&#8217; to figure out what&#8217;s taking query so long.\u00a0 My thanks to Dennis Zwahlen (a Data and AI CSA &#8211; <a href=\"https:\/\/www.linkedin.com\/in\/dennis-zwahlen-9b85292\/\" target=\"_blank\" rel=\"noopener\">LinkedIn<\/a> ) helping me figure out what was causing a SCOM DW SQL query to render data VERY slowly!<\/p>\n<p>&nbsp;<\/p>\n<p>Don&#8217;t get me wrong, the sheer volume of events is definitely part of the problem.\u00a0 \u00a0Event rules are using expressions to further restrict collected event data.<\/p>\n<p><a style=\"font-weight: bold; background-color: transparent; text-align: inherit;\" href=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SCOMDWSecurityEvents.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-19572\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SCOMDWSecurityEvents.jpg\" alt=\"SCOM DW Events ingested for DC Security Events when SIEM is a limit, and NOT using ACS feature\" width=\"517\" height=\"404\" srcset=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SCOMDWSecurityEvents.jpg 517w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SCOMDWSecurityEvents-300x234.jpg 300w\" sizes=\"auto, (max-width: 517px) 85vw, 517px\" \/><\/a><\/p>\n<p>SCOM DW Events ingested for DC Security Events when SIEM is a limit, and NOT using ACS feature.\u00a0 Will discuss the SCOM DW Event ingestion and additional XML authoring options to turn down the pressure.<\/p>\n<p>&nbsp;<\/p>\n<p>Time to use the &#8216;SQL query Plan howto&#8217; blog for SQL execution plan, to help to figure out why the DW Query takes so long.\u00a0 Using the execution plan, similar to SQL profiler, will provide insight to possibly speed up query, allowing PowerBI app\/report rendering of data.<\/p>\n<p>From SSMS &gt; View &gt; Add Display Estimated Execution Plan<\/p>\n<figure id=\"attachment_19609\" aria-describedby=\"caption-attachment-19609\" style=\"width: 579px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/08\/SSMS-SQLQueryPlan.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-19609\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/08\/SSMS-SQLQueryPlan.png\" alt=\"From SSMS &gt; View &gt; Add Display Estimated Execution Plan\" width=\"579\" height=\"487\" srcset=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/08\/SSMS-SQLQueryPlan.png 579w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/08\/SSMS-SQLQueryPlan-300x252.png 300w\" sizes=\"auto, (max-width: 579px) 85vw, 579px\" \/><\/a><figcaption id=\"caption-attachment-19609\" class=\"wp-caption-text\">From SSMS &gt; View &gt; Add Display Estimated Execution Plan<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>SQL execution plan starting from the left documenting SQL query<br \/>\n<a style=\"font-weight: bold; background-color: transparent; text-align: inherit;\" href=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SQLQueryPlan1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-19573\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SQLQueryPlan1.jpg\" alt=\"SQL query plan starting from the left documenting SQL query\" width=\"1142\" height=\"208\" srcset=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SQLQueryPlan1.jpg 1142w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SQLQueryPlan1-300x55.jpg 300w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SQLQueryPlan1-768x140.jpg 768w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SQLQueryPlan1-1024x187.jpg 1024w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/a><\/p>\n<p>SQL query plan starting from the left documenting SQL query<\/p>\n<p>Sort is taking 4.5 minutes in this example of the SQL execution plan visual.\u00a0 You can see moving right from the Join lines documents how SQL behaves, and how each piece affects overall execution.<\/p>\n<figure id=\"attachment_19574\" aria-describedby=\"caption-attachment-19574\" style=\"width: 1138px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SQLQueryPlan2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-19574\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SQLQueryPlan2.jpg\" alt=\"SQL query plan starting moving right from the left documenting SQL query\" width=\"1138\" height=\"214\" srcset=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SQLQueryPlan2.jpg 1138w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SQLQueryPlan2-300x56.jpg 300w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SQLQueryPlan2-768x144.jpg 768w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/SQLQueryPlan2-1024x193.jpg 1024w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/a><figcaption id=\"caption-attachment-19574\" class=\"wp-caption-text\">SQL query plan starting moving right from the left documenting SQL query<\/figcaption><\/figure>\n<p>Hope this helps for another diagnostic SQL step in your tool box!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ever need to build out a capability and the SQL query is your blocker?\u00a0 Use a SQL query Plan &#8216;howTo&#8217; to figure out what&#8217;s taking query so long.\u00a0 My thanks to Dennis Zwahlen (a Data and AI CSA &#8211; LinkedIn ) helping me figure out what was causing a SCOM DW SQL query to render &hellip; <a href=\"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;SQL query Plan howto&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,5,530,556,11],"tags":[666,671,665,664,410,670,663],"class_list":["post-19570","post","type-post","status-publish","format-standard","hentry","category-administration","category-best-practice","category-scom","category-sql","category-troubleshooting","tag-event-collection-rule","tag-mapping-sql-query-performance","tag-scom-acs","tag-scom-dw","tag-sql","tag-sql-execution-plan","tag-sql-query-plan"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL query Plan howto - Kevin Justin&#039;s Blog<\/title>\n<meta name=\"description\" content=\"Use SQL query plan howto blog to help diagnose what in your sql query execution is causing slow execution\/results\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL query Plan howto - Kevin Justin&#039;s Blog\" \/>\n<meta property=\"og:description\" content=\"Use SQL query plan howto blog to help diagnose what in your sql query execution is causing slow execution\/results\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/\" \/>\n<meta property=\"og:site_name\" content=\"Kevin Justin&#039;s Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-02T10:21:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-02T10:21:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/CantYouDoAnythingRight.jpg\" \/>\n<meta name=\"author\" content=\"WordPress Administrator\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"WordPress Administrator\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/02\\\/sql-query-plan-howto-diagnose-sql-query-execution\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/02\\\/sql-query-plan-howto-diagnose-sql-query-execution\\\/\"},\"author\":{\"name\":\"WordPress Administrator\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/3d7a90f4430bef43134eaa0a7e2cd508\"},\"headline\":\"SQL query Plan howto\",\"datePublished\":\"2023-08-02T10:21:22+00:00\",\"dateModified\":\"2023-08-02T10:21:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/02\\\/sql-query-plan-howto-diagnose-sql-query-execution\\\/\"},\"wordCount\":303,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/02\\\/sql-query-plan-howto-diagnose-sql-query-execution\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/CantYouDoAnythingRight.jpg\",\"keywords\":[\"Event collection rule\",\"mapping SQL query performance\",\"SCOM ACS\",\"SCOM DW\",\"sql\",\"SQL Execution plan\",\"SQL Query Plan\"],\"articleSection\":[\"Administration\",\"Best Practice\",\"SCOM\",\"SQL\",\"Troubleshooting\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/02\\\/sql-query-plan-howto-diagnose-sql-query-execution\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/02\\\/sql-query-plan-howto-diagnose-sql-query-execution\\\/\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/02\\\/sql-query-plan-howto-diagnose-sql-query-execution\\\/\",\"name\":\"SQL query Plan howto - Kevin Justin&#039;s Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/02\\\/sql-query-plan-howto-diagnose-sql-query-execution\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/02\\\/sql-query-plan-howto-diagnose-sql-query-execution\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/CantYouDoAnythingRight.jpg\",\"datePublished\":\"2023-08-02T10:21:22+00:00\",\"dateModified\":\"2023-08-02T10:21:56+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/3d7a90f4430bef43134eaa0a7e2cd508\"},\"description\":\"Use SQL query plan howto blog to help diagnose what in your sql query execution is causing slow execution\\\/results\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/02\\\/sql-query-plan-howto-diagnose-sql-query-execution\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/02\\\/sql-query-plan-howto-diagnose-sql-query-execution\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/02\\\/sql-query-plan-howto-diagnose-sql-query-execution\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/CantYouDoAnythingRight.jpg\",\"contentUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/CantYouDoAnythingRight.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/02\\\/sql-query-plan-howto-diagnose-sql-query-execution\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL query Plan howto\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/\",\"name\":\"Kevin Justin&#039;s Blog\",\"description\":\"Operational monitoring tools including System Center, Azure Monitor\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/3d7a90f4430bef43134eaa0a7e2cd508\",\"name\":\"WordPress Administrator\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g\",\"caption\":\"WordPress Administrator\"},\"sameAs\":[\"https:\\\/\\\/kevinjustin.com\"],\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/author\\\/wordpress_admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL query Plan howto - Kevin Justin&#039;s Blog","description":"Use SQL query plan howto blog to help diagnose what in your sql query execution is causing slow execution\/results","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:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/","og_locale":"en_US","og_type":"article","og_title":"SQL query Plan howto - Kevin Justin&#039;s Blog","og_description":"Use SQL query plan howto blog to help diagnose what in your sql query execution is causing slow execution\/results","og_url":"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/","og_site_name":"Kevin Justin&#039;s Blog","article_published_time":"2023-08-02T10:21:22+00:00","article_modified_time":"2023-08-02T10:21:56+00:00","og_image":[{"url":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/CantYouDoAnythingRight.jpg","type":"","width":"","height":""}],"author":"WordPress Administrator","twitter_card":"summary_large_image","twitter_misc":{"Written by":"WordPress Administrator","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/#article","isPartOf":{"@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/"},"author":{"name":"WordPress Administrator","@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/3d7a90f4430bef43134eaa0a7e2cd508"},"headline":"SQL query Plan howto","datePublished":"2023-08-02T10:21:22+00:00","dateModified":"2023-08-02T10:21:56+00:00","mainEntityOfPage":{"@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/"},"wordCount":303,"commentCount":0,"image":{"@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/#primaryimage"},"thumbnailUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/CantYouDoAnythingRight.jpg","keywords":["Event collection rule","mapping SQL query performance","SCOM ACS","SCOM DW","sql","SQL Execution plan","SQL Query Plan"],"articleSection":["Administration","Best Practice","SCOM","SQL","Troubleshooting"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/","url":"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/","name":"SQL query Plan howto - Kevin Justin&#039;s Blog","isPartOf":{"@id":"https:\/\/kevinjustin.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/#primaryimage"},"image":{"@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/#primaryimage"},"thumbnailUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/CantYouDoAnythingRight.jpg","datePublished":"2023-08-02T10:21:22+00:00","dateModified":"2023-08-02T10:21:56+00:00","author":{"@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/3d7a90f4430bef43134eaa0a7e2cd508"},"description":"Use SQL query plan howto blog to help diagnose what in your sql query execution is causing slow execution\/results","breadcrumb":{"@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/#primaryimage","url":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/CantYouDoAnythingRight.jpg","contentUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/07\/CantYouDoAnythingRight.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/02\/sql-query-plan-howto-diagnose-sql-query-execution\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kevinjustin.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL query Plan howto"}]},{"@type":"WebSite","@id":"https:\/\/kevinjustin.com\/blog\/#website","url":"https:\/\/kevinjustin.com\/blog\/","name":"Kevin Justin&#039;s Blog","description":"Operational monitoring tools including System Center, Azure Monitor","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kevinjustin.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/3d7a90f4430bef43134eaa0a7e2cd508","name":"WordPress Administrator","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g","caption":"WordPress Administrator"},"sameAs":["https:\/\/kevinjustin.com"],"url":"https:\/\/kevinjustin.com\/blog\/author\/wordpress_admin\/"}]}},"_links":{"self":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/19570","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/comments?post=19570"}],"version-history":[{"count":7,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/19570\/revisions"}],"predecessor-version":[{"id":19613,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/19570\/revisions\/19613"}],"wp:attachment":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/media?parent=19570"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/categories?post=19570"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/tags?post=19570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}