{"id":2027,"date":"2016-09-08T10:27:04","date_gmt":"2016-09-08T14:27:04","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/jonathan\/?p=2027"},"modified":"2017-04-13T13:05:55","modified_gmt":"2017-04-13T17:05:55","slug":"sql-sentry-plan-explorer-completely-free","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/","title":{"rendered":"SQL Sentry Plan Explorer Completely Free!"},"content":{"rendered":"<p>Just in case you missed the <a href=\"https:\/\/blogs.sentryone.com\/greggonzalez\/plan-explorer-pro-goes-free\/\" target=\"_blank\">announcement by Greg Gonzalez at SQL Sentry <\/a>this morning, Plan Explorer Pro and what would have become Plan Explorer Ultimate are now completely free.<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2016\/09\/plan-explorer-blog-post.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-2029 size-full\" src=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2016\/09\/plan-explorer-blog-post.png\" alt=\"plan-explorer-blog-post\" width=\"584\" height=\"390\" \/><\/a><\/p>\n<p>Since SQL Sentry first released Plan Explorer in late 2007, I have been a huge fan and this is a tool that is one of my most heavily used in consulting work. I recommend it to clients almost everyday and routinely demonstrate the different editions during our Immersion Events and at SQL Saturdays. Where the previous Free edition simplified analysis of execution plans, the new features that have been added from the previous Pro edition and what would have become Ultimate edition make this hands down the best tool for performance tuning and execution plan analysis. The new <a href=\"https:\/\/blogs.sentryone.com\/aaronbertrand\/sql-sentry-v10-index-analysis\/\" target=\"_blank\">Index Analysis <\/a>tab with statistics histogram graphed out will make analyzing plan skew due to parameter sensitivity much easier. This is a feature that I&#8217;ve been waiting to see live for months now and can&#8217;t wait to make more use of in client engagements.<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2016\/09\/index-analysis.png\"><img decoding=\"async\" class=\"aligncenter wp-image-2030 size-large\" src=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2016\/09\/index-analysis-1024x462.png\" alt=\"index-analysis\" width=\"1024\" height=\"462\" \/><\/a><\/p>\n<p>Add to that the ability to analyze deadlock graphs, collection of execution wait statistics with Extended Events, query execution plan history with notes, and advanced plan layout and filtering options. Now it is all COMPLETELY FREE!\u00a0 As if that&#8217;s not good enough, you can also attend a free query tuning seminar with Aaron Bertrand on Friday September 9th 11:00AM-12:00PM EST where he will demonstrate how to use the new tool more effectively.<\/p>\n<p><a href=\"http:\/\/sqlsentry.tv\/sql-sentry-plan-explorer-3-0\/\">Free Seminar on Query Tuning<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Just in case you missed the announcement by Greg Gonzalez at SQL Sentry this morning, Plan Explorer Pro and what would have become Plan Explorer Ultimate are now completely free. Since SQL Sentry first released Plan Explorer in late 2007, I have been a huge fan and this is a tool that is one of [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[],"class_list":["post-2027","post","type-post","status-publish","format-standard","hentry","category-performance-tuning"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Sentry Plan Explorer Completely Free! - Jonathan Kehayias<\/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\/jonathan\/sql-sentry-plan-explorer-completely-free\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Sentry Plan Explorer Completely Free! - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"Just in case you missed the announcement by Greg Gonzalez at SQL Sentry this morning, Plan Explorer Pro and what would have become Plan Explorer Ultimate are now completely free. Since SQL Sentry first released Plan Explorer in late 2007, I have been a huge fan and this is a tool that is one of [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-08T14:27:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T17:05:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2016\/09\/plan-explorer-blog-post.png\" \/>\n<meta name=\"author\" content=\"Jonathan Kehayias\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan Kehayias\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-sentry-plan-explorer-completely-free\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-sentry-plan-explorer-completely-free\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"SQL Sentry Plan Explorer Completely Free!\",\"datePublished\":\"2016-09-08T14:27:04+00:00\",\"dateModified\":\"2017-04-13T17:05:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-sentry-plan-explorer-completely-free\\\/\"},\"wordCount\":258,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-sentry-plan-explorer-completely-free\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2016\\\/09\\\/plan-explorer-blog-post.png\",\"articleSection\":[\"Performance Tuning\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-sentry-plan-explorer-completely-free\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-sentry-plan-explorer-completely-free\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-sentry-plan-explorer-completely-free\\\/\",\"name\":\"SQL Sentry Plan Explorer Completely Free! - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-sentry-plan-explorer-completely-free\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-sentry-plan-explorer-completely-free\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2016\\\/09\\\/plan-explorer-blog-post.png\",\"datePublished\":\"2016-09-08T14:27:04+00:00\",\"dateModified\":\"2017-04-13T17:05:55+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-sentry-plan-explorer-completely-free\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-sentry-plan-explorer-completely-free\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-sentry-plan-explorer-completely-free\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2016\\\/09\\\/Plan-Explorer-Blog-Post.png\",\"contentUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2016\\\/09\\\/Plan-Explorer-Blog-Post.png\",\"width\":584,\"height\":390},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-sentry-plan-explorer-completely-free\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performance Tuning\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/performance-tuning\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Sentry Plan Explorer Completely Free!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\",\"name\":\"Jonathan Kehayias - The Rambling DBA\",\"description\":\"The Rambling DBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/?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\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\",\"name\":\"Jonathan Kehayias\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"caption\":\"Jonathan Kehayias\"},\"sameAs\":[\"http:\\\/\\\/3.209.169.194\\\/blogs\\\/jonathan\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Sentry Plan Explorer Completely Free! - Jonathan Kehayias","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\/jonathan\/sql-sentry-plan-explorer-completely-free\/","og_locale":"en_US","og_type":"article","og_title":"SQL Sentry Plan Explorer Completely Free! - Jonathan Kehayias","og_description":"Just in case you missed the announcement by Greg Gonzalez at SQL Sentry this morning, Plan Explorer Pro and what would have become Plan Explorer Ultimate are now completely free. Since SQL Sentry first released Plan Explorer in late 2007, I have been a huge fan and this is a tool that is one of [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/","og_site_name":"Jonathan Kehayias","article_published_time":"2016-09-08T14:27:04+00:00","article_modified_time":"2017-04-13T17:05:55+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2016\/09\/plan-explorer-blog-post.png","type":"","width":"","height":""}],"author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"SQL Sentry Plan Explorer Completely Free!","datePublished":"2016-09-08T14:27:04+00:00","dateModified":"2017-04-13T17:05:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/"},"wordCount":258,"commentCount":0,"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2016\/09\/plan-explorer-blog-post.png","articleSection":["Performance Tuning"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/","name":"SQL Sentry Plan Explorer Completely Free! - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2016\/09\/plan-explorer-blog-post.png","datePublished":"2016-09-08T14:27:04+00:00","dateModified":"2017-04-13T17:05:55+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2016\/09\/Plan-Explorer-Blog-Post.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2016\/09\/Plan-Explorer-Blog-Post.png","width":584,"height":390},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-sentry-plan-explorer-completely-free\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"Performance Tuning","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/performance-tuning\/"},{"@type":"ListItem","position":3,"name":"SQL Sentry Plan Explorer Completely Free!"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/","name":"Jonathan Kehayias - The Rambling DBA","description":"The Rambling DBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/?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\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c","name":"Jonathan Kehayias","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","caption":"Jonathan Kehayias"},"sameAs":["http:\/\/3.209.169.194\/blogs\/jonathan"]}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/2027","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/comments?post=2027"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/2027\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=2027"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=2027"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=2027"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}