{"id":753,"date":"2016-04-01T11:00:46","date_gmt":"2016-04-01T18:00:46","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/erin\/?p=753"},"modified":"2017-04-13T09:19:31","modified_gmt":"2017-04-13T16:19:31","slug":"why-do-you-avoid-extended-events","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/why-do-you-avoid-extended-events\/","title":{"rendered":"Why do YOU avoid Extended Events?"},"content":{"rendered":"<p>On Monday this week I had an interesting exchange on Twitter with a bunch of folks who are die-hard Profiler\/Trace users, and have no interest in using Extended Events.\u00a0 To wit:<\/p>\n<figure id=\"attachment_754\" aria-describedby=\"caption-attachment-754\" style=\"width: 588px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2016\/04\/denny_profiler.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-754\" src=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2016\/04\/denny_profiler.jpg\" alt=\"Tweet from Denny about Profiler (used with permission)\" width=\"588\" height=\"105\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2016\/04\/denny_profiler.jpg 588w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2016\/04\/denny_profiler-300x54.jpg 300w\" sizes=\"(max-width: 588px) 100vw, 588px\" \/><\/a><figcaption id=\"caption-attachment-754\" class=\"wp-caption-text\">Tweet from Denny about Profiler (used with permission)<\/figcaption><\/figure>\n<p>Now, Denny and I are good friends, and his tweet didn\u2019t upset me in any way, it just got me thinking.\u00a0 Why are DBAs and developers so resistant to using Extended Events?\u00a0 I have some theories, but I realized I should collect some data.<\/p>\n<p>Therefore, whether you:<\/p>\n<ul>\n<li>Have never tried Extended Events,<\/li>\n<li>Have tried Extended Events but would rather keep using Profiler\/Trace,<\/li>\n<li>Use Extended Events occasionally but still prefer Profiler\/Trace,<\/li>\n<\/ul>\n<p>I want to hear from you.\u00a0 Whatever the reason, I want to know \u2013 so please leave a comment below.\u00a0 My goal is to understand what the main challenges are so that I can then provide options and solutions, or create Connect items for the product team to address any gaps in functionality.<\/p>\n<p>Extended Events *is* the replacement for Profiler\/Trace; it\u2019s not going away.\u00a0 I really want people to be prepared for the time when Profiler and Trace are removed from the product.\u00a0 And I want to provide feedback to the SQL Server product team to address limitations that people find in Extended Events.\u00a0 If the feature is lacking something, we need to work together to create change.<\/p>\n<p>Thanks in advance for your help, and if you haven\u2019t tried XE, or are looking for a refresher, then please attend my webinar next Tuesday, April 5<sup>th<\/sup> at 12PM EDT: <a href=\"http:\/\/fundamentals.pass.org\/MeetingDetails.aspx?EventID=4265\" class=\"broken_link\">Kicking and Screaming: Replacing Profiler with Extended Events<\/a>.\u00a0 I\u2019d love to see you there and can help get you started with XE!<\/p>\n<p><em>EDIT 2:37PM EDT: If you are still running 2008 or 2008R2, then our advice has always been to stick with Trace and Profiler.\u00a0 If you&#8217;re running SQL Server 2012 and higher, then I recommended Extended Events.\u00a0 Why?\u00a0 Because it wasn&#8217;t until SQL Server 2012 that every event from Trace had a comparable event in Extended Events.\u00a0 So,if your argument is that you don&#8217;t want to learn XQuery and XML because you&#8217;re on 2008 or 2008R2, I&#8217;m right there with you and will tell you that&#8217;s fine, wait until 2012 to use XE.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>On Monday this week I had an interesting exchange on Twitter with a bunch of folks who are die-hard Profiler\/Trace users, and have no interest in using Extended Events.\u00a0 To wit: Now, Denny and I are good friends, and his tweet didn\u2019t upset me in any way, it just got me thinking.\u00a0 Why are DBAs [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Why do YOU avoid Extended Events? - Erin Stellato<\/title>\n<meta name=\"description\" content=\"Are you still using Profiler and Trace, even though Extended Events is the replacement for both? I want to know why, please read and comment in this post!\" \/>\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\/erin\/why-do-you-avoid-extended-events\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Why do YOU avoid Extended Events? - Erin Stellato\" \/>\n<meta property=\"og:description\" content=\"Are you still using Profiler and Trace, even though Extended Events is the replacement for both? I want to know why, please read and comment in this post!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/why-do-you-avoid-extended-events\/\" \/>\n<meta property=\"og:site_name\" content=\"Erin Stellato\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-01T18:00:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:19:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2016\/04\/denny_profiler.jpg\" \/>\n<meta name=\"author\" content=\"Erin Stellato\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Erin Stellato\" \/>\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\/erin\/why-do-you-avoid-extended-events\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/why-do-you-avoid-extended-events\/\",\"name\":\"Why do YOU avoid Extended Events? - Erin Stellato\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\"},\"datePublished\":\"2016-04-01T18:00:46+00:00\",\"dateModified\":\"2017-04-13T16:19:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\"},\"description\":\"Are you still using Profiler and Trace, even though Extended Events is the replacement for both? I want to know why, please read and comment in this post!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/why-do-you-avoid-extended-events\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/erin\/why-do-you-avoid-extended-events\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/why-do-you-avoid-extended-events\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Why do YOU avoid Extended Events?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\",\"name\":\"Erin Stellato\",\"description\":\"The SQL Sequel\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\",\"name\":\"Erin Stellato\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"caption\":\"Erin Stellato\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/erin\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Why do YOU avoid Extended Events? - Erin Stellato","description":"Are you still using Profiler and Trace, even though Extended Events is the replacement for both? I want to know why, please read and comment in this post!","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\/erin\/why-do-you-avoid-extended-events\/","og_locale":"en_US","og_type":"article","og_title":"Why do YOU avoid Extended Events? - Erin Stellato","og_description":"Are you still using Profiler and Trace, even though Extended Events is the replacement for both? I want to know why, please read and comment in this post!","og_url":"https:\/\/www.sqlskills.com\/blogs\/erin\/why-do-you-avoid-extended-events\/","og_site_name":"Erin Stellato","article_published_time":"2016-04-01T18:00:46+00:00","article_modified_time":"2017-04-13T16:19:31+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2016\/04\/denny_profiler.jpg"}],"author":"Erin Stellato","twitter_misc":{"Written by":"Erin Stellato","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/why-do-you-avoid-extended-events\/","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/why-do-you-avoid-extended-events\/","name":"Why do YOU avoid Extended Events? - Erin Stellato","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website"},"datePublished":"2016-04-01T18:00:46+00:00","dateModified":"2017-04-13T16:19:31+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158"},"description":"Are you still using Profiler and Trace, even though Extended Events is the replacement for both? I want to know why, please read and comment in this post!","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/why-do-you-avoid-extended-events\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/erin\/why-do-you-avoid-extended-events\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/why-do-you-avoid-extended-events\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/erin\/"},{"@type":"ListItem","position":2,"name":"Why do YOU avoid Extended Events?"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/","name":"Erin Stellato","description":"The SQL Sequel","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158","name":"Erin Stellato","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","caption":"Erin Stellato"},"sameAs":["http:\/\/3.209.169.194\/blogs\/erin"],"url":"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/753"}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/comments?post=753"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/753\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/media?parent=753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/categories?post=753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/tags?post=753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}