{"id":2932,"date":"2013-06-21T11:32:26","date_gmt":"2013-06-21T10:32:26","guid":{"rendered":"http:\/\/andreas-wolter.com\/umfrage-welche-tracing-und-analyse-tools-verwendet-ihr-fuer-sql-server\/"},"modified":"2017-10-09T18:31:28","modified_gmt":"2017-10-09T17:31:28","slug":"survey-which-tracing-and-analysis-tools-do-you-use-for-sql-server","status":"publish","type":"post","link":"https:\/\/andreas-wolter.com\/en\/survey-which-tracing-and-analysis-tools-do-you-use-for-sql-server\/","title":{"rendered":"Survey: Which Tracing and Analysis-Tools do you use for SQL Server?"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_heading-3817909b93e181f361e9e2b50135d47c\">\n#top .av-special-heading.av-av_heading-3817909b93e181f361e9e2b50135d47c{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-av_heading-3817909b93e181f361e9e2b50135d47c .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-av_heading-3817909b93e181f361e9e2b50135d47c .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-av_heading-3817909b93e181f361e9e2b50135d47c av-special-heading-h3 blockquote modern-quote  avia-builder-el-0  el_before_av_textblock  avia-builder-el-first '><h3 class='av-special-heading-tag'  itemprop=\"headline\"  >Survey: Which Tracing and Analysis-Tools do you use for SQL Server?<\/h3><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>In my session Session \u201eHasta la vista Profiler \u2013 Tracing with Extended Events\u201c, which I have presented at several occasions, I used to ask the audience which tools they used for monitoring so far.<\/p>\n<p>I would like to use this platform to survey on a broader range as to which tools are being used by SQL Server professionals for logging and analyzing performance-problems. In order to get a differentiated result, a classification in \u201cAdministrator\u201d and \u201cDeveloper\u201d is certainly also interesting.<!--more--><\/p>\n<p>The results will be presented first at the upcoming <a href=\"http:\/\/sqlsaturday.com\/230\/\" target=\"_blank\" rel=\"noopener\">SQLSaturday #230 <\/a>on the 12th of Juli in St. Augustin\/Germany at the PreCon, <a href=\"http:\/\/sqlsaturday230.eventbrite.de\/\" target=\"_blank\" rel=\"noopener\">From SQL Traces to Extended Events. The next big switch<\/a>.\u201c, which I will be giving together with Mladen Prajdic gebe, and later on certainly also at the <a href=\"http:\/\/www.sqlpasscamp.de\/\" target=\"_blank\" rel=\"noopener\">PASS Camp<\/a> and other occasions of the German and international PASS &#8211; and of course also here in my blog itself. You can of course also keep your comments anonymous.<\/p>\n<p>In the following I am listing a series of common tools.<\/p>\n<p>Please simply provide your vote as a comment like in the following example \u2013 I will publish ALL answers (except plain spam\/ads), even Oracle-Tools \ud83d\ude09<\/p>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><strong>\u201eAdministrator and\/or Developer\u201c<\/strong> <strong>A 3<\/strong> <strong>B 1<\/strong> <strong>D 2 L 0<\/strong><\/p>\n<p>The numbers stand for:<\/p>\n<p><strong>3: fast immer \/\/ almost all the time<\/strong> <strong>2: manchmal \/\/ sometimes<\/strong> <strong>1: selten \/\/ rarely<\/strong> <strong>-1: das Tool ist mir unbekannt \/\/ I haven&#8217;t hear of this tool<\/strong><\/p>\n<p>The option \u201cunknown\u201d at a reader\u2019s suggestion (Thank you!).<\/p>\n<p>Tools that are not used can be simply left out.<\/p>\n<p>And these are the choices of tools:<\/p>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><strong>A) ClearTrace<\/strong><br \/>\n<strong> B) Datenbankoptimierungsratgeber \/\/ Database Engine Tuning Advisor <\/strong><br \/>\n<strong> C) Dynamic Management Views (DMV&#8217;s)<\/strong><br \/>\n<strong> D) Event Notifications<\/strong><br \/>\n<strong> E) Extended Events unter 2008\/R2<\/strong><br \/>\n<strong> F) Extended Events unter 2012<\/strong><br \/>\n<strong> G) Management Datawarehouse (MDW) \/ Data Collection Reports<\/strong><br \/>\n<strong> H) PAL<\/strong><br \/>\n<strong> I) PerfMon<\/strong><br \/>\n<strong> J) RML Utilities \/ ReadTrace<\/strong><br \/>\n<strong> K) SQL Diag<\/strong><br \/>\n<strong> L) SQL Profiler<\/strong><br \/>\n<strong> M) SQL Trace<\/strong><br \/>\n<strong> N) Software von Drittherstellern \u2013 siehe auch O) \/\/ Third-Party Tools &#8211; also see O)<\/strong><br \/>\n<strong> O) Andere \/\/ Other: \u2026<\/strong><\/p>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>&#8211; The order is alphabetical and not supposed to imply anything \ud83d\ude42<\/p>\n<p>My list contains solely tools shipped with SQL Server and from codeplex, but feel free to add others (point \u201cO\u201d)<\/p>\n<p>I am totally aware that also the SQL Server version and possibly edition have an influence on the choices available, but I also do not want to make the survey all too complex. The aim of gaining an impression on the prevalence and practices of tracing-habits will certainly be reached like that, too \ud83d\ude42<\/p>\n<p>Thank you very much for participating \u2013 I am sure that many members of the SQL Server Community are also interested in seeing what others use for their work.<\/p>\n<p>Andreas<\/p>\n<\/div><\/section>\r\n\r\n<div  class='hr av-av_hr-0ff602b3e980a3377077ff3c1c834df6 hr-default  avia-builder-el-5  el_after_av_textblock  el_before_av_social_share '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n<div  class='av-social-sharing-box av-av_social_share-8644d330ffb238fff0cfa858c5295467 av-social-sharing-box-default  avia-builder-el-6  el_after_av_hr  el_before_av_comments_list  av-social-sharing-box-fullwidth'><div class=\"av-share-box\"><h5 class='av-share-link-description av-no-toc '>Share<\/h5><ul class=\"av-share-box-list noLightbox\"><li class='av-share-link av-social-link-facebook' ><a target=\"_blank\" aria-label=\"Share on Facebook\" href=\"https:\/\/www.facebook.com\/sharer.php?u=https:\/\/andreas-wolter.com\/en\/survey-which-tracing-and-analysis-tools-do-you-use-for-sql-server\/&#038;t=Survey%3A%20Which%20Tracing%20and%20Analysis-Tools%20do%20you%20use%20for%20SQL%20Server%3F\" aria-hidden=\"false\" data-av_icon=\"\ue8f3\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on Facebook\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on Facebook<\/span><\/a><\/li><li class='av-share-link av-social-link-twitter' ><a target=\"_blank\" aria-label=\"Share on Twitter\" href=\"https:\/\/twitter.com\/share?text=Survey%3A%20Which%20Tracing%20and%20Analysis-Tools%20do%20you%20use%20for%20SQL%20Server%3F&#038;url=https:\/\/andreas-wolter.com\/en\/?p=2932\" aria-hidden=\"false\" data-av_icon=\"\ue8f1\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on Twitter\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on Twitter<\/span><\/a><\/li><li class='av-share-link av-social-link-linkedin' ><a target=\"_blank\" aria-label=\"Share on LinkedIn\" href=\"https:\/\/linkedin.com\/shareArticle?mini=true&#038;title=Survey%3A%20Which%20Tracing%20and%20Analysis-Tools%20do%20you%20use%20for%20SQL%20Server%3F&#038;url=https:\/\/andreas-wolter.com\/en\/survey-which-tracing-and-analysis-tools-do-you-use-for-sql-server\/\" aria-hidden=\"false\" data-av_icon=\"\ue8fc\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on LinkedIn\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on LinkedIn<\/span><\/a><\/li><\/ul><\/div><\/div>\r\n\r\n<div  class='av-buildercomment av-av_comments_list-88ce68e426f11248fa394058a3de040f  av-blog-meta-author-disabled av-blog-meta-html-info-disabled'><\/div>","protected":false},"excerpt":{"rendered":"In my session Session \u201eHasta la vista Profiler \u2013 Tracing with Extended Events\u201c, which I have presented at several occasions, I used to ask the audience which tools they used for monitoring so far. I would like to use this platform to survey on a broader range as to which tools are being used by [&hellip;]","protected":false},"author":4,"featured_media":4315,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55,131,64,133,56],"tags":[19,179,187,188,182,189],"class_list":["post-2932","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-extended-events-en","category-sql-trace-profiler","category-sqlpass-en","category-surveysumfragen","category-tracing-monitoring-en","tag-performance-analysis-en","tag-sqlsaturday-en","tag-survey-en","tag-tools-en","tag-tracing-en","tag-umfrage-en"],"_links":{"self":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/2932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/comments?post=2932"}],"version-history":[{"count":3,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/2932\/revisions"}],"predecessor-version":[{"id":3020,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/2932\/revisions\/3020"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media\/4315"}],"wp:attachment":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media?parent=2932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/categories?post=2932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/tags?post=2932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}