{"id":767,"date":"2016-06-02T08:01:19","date_gmt":"2016-06-02T15:01:19","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/erin\/?p=767"},"modified":"2016-06-02T08:01:19","modified_gmt":"2016-06-02T15:01:19","slug":"tell-me-how-you-use-profiler-and-trace","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/tell-me-how-you-use-profiler-and-trace\/","title":{"rendered":"Tell me how you use Profiler and Trace"},"content":{"rendered":"

Back in April I wrote a post asking why people tend to avoid Extended Events<\/a>.\u00a0 Many of you provided feedback, which I greatly<\/em> appreciated.\u00a0 A common theme in the responses was time.\u00a0 Many people found that creating an event session in Extended Events that was comparable to one they would create in Trace took longer.\u00a0 Ok, I get that…so as a follow up I am interested in knowing how you typically use Profiler and Trace.\u00a0 If you would be willing to share that information, I would be extremely grateful.\u00a0 At a minimum, I’d like to know what events you add, what columns you select for those events, what filters you add, and then how you view the data (e.g. do you run Profiler and watch the data live, or do you script it out as a server side trace and write it to a file, then view it later for analysis?).\u00a0 If it’s easiest to post the trace definition (i.e. export it from the Profiler UI) that works too.\u00a0 Again, any information you can share in the comments (or if you want to send me an email that’s great too) would be greatly appreciated.\u00a0 My goal is to create a library of event session definitions for these “typical” traces that people create and share them publicly.\u00a0 Stay tuned for another post once I (hopefully!) start getting some information.\u00a0 Thanks again!<\/p>\n","protected":false},"excerpt":{"rendered":"

Back in April I wrote a post asking why people tend to avoid Extended Events.\u00a0 Many of you provided feedback, which I greatly appreciated.\u00a0 A common theme in the responses was time.\u00a0 Many people found that creating an event session in Extended Events that was comparable to one they would create in Trace took longer.\u00a0 […]<\/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":"\nTell me how you use Profiler and Trace - Erin Stellato<\/title>\n<meta name=\"description\" content=\"Help me out and tell me how you use Profiler and Trace, so I can create comparable event session definitions for Extended Events.\" \/>\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\/tell-me-how-you-use-profiler-and-trace\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tell me how you use Profiler and Trace - Erin Stellato\" \/>\n<meta property=\"og:description\" content=\"Help me out and tell me how you use Profiler and Trace, so I can create comparable event session definitions for Extended Events.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/tell-me-how-you-use-profiler-and-trace\/\" \/>\n<meta property=\"og:site_name\" content=\"Erin Stellato\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-02T15:01:19+00:00\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/tell-me-how-you-use-profiler-and-trace\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/tell-me-how-you-use-profiler-and-trace\/\",\"name\":\"Tell me how you use Profiler and Trace - Erin Stellato\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\"},\"datePublished\":\"2016-06-02T15:01:19+00:00\",\"dateModified\":\"2016-06-02T15:01:19+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\"},\"description\":\"Help me out and tell me how you use Profiler and Trace, so I can create comparable event session definitions for Extended Events.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/tell-me-how-you-use-profiler-and-trace\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/erin\/tell-me-how-you-use-profiler-and-trace\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/tell-me-how-you-use-profiler-and-trace\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tell me how you use Profiler and Trace\"}]},{\"@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":"Tell me how you use Profiler and Trace - Erin Stellato","description":"Help me out and tell me how you use Profiler and Trace, so I can create comparable event session definitions for Extended Events.","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\/tell-me-how-you-use-profiler-and-trace\/","og_locale":"en_US","og_type":"article","og_title":"Tell me how you use Profiler and Trace - Erin Stellato","og_description":"Help me out and tell me how you use Profiler and Trace, so I can create comparable event session definitions for Extended Events.","og_url":"https:\/\/www.sqlskills.com\/blogs\/erin\/tell-me-how-you-use-profiler-and-trace\/","og_site_name":"Erin Stellato","article_published_time":"2016-06-02T15:01:19+00:00","author":"Erin Stellato","twitter_misc":{"Written by":"Erin Stellato","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/tell-me-how-you-use-profiler-and-trace\/","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/tell-me-how-you-use-profiler-and-trace\/","name":"Tell me how you use Profiler and Trace - Erin Stellato","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website"},"datePublished":"2016-06-02T15:01:19+00:00","dateModified":"2016-06-02T15:01:19+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158"},"description":"Help me out and tell me how you use Profiler and Trace, so I can create comparable event session definitions for Extended Events.","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/tell-me-how-you-use-profiler-and-trace\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/erin\/tell-me-how-you-use-profiler-and-trace\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/tell-me-how-you-use-profiler-and-trace\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/erin\/"},{"@type":"ListItem","position":2,"name":"Tell me how you use Profiler and Trace"}]},{"@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\/767"}],"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=767"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/767\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/media?parent=767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/categories?post=767"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/tags?post=767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}