{"id":2898,"date":"2013-08-23T17:26:01","date_gmt":"2013-08-23T16:26:01","guid":{"rendered":"http:\/\/andreas-wolter.com\/precon-performance-analyse-tuning-techniken-auf-dem-sqlsaturday-in-istanbul\/"},"modified":"2017-10-09T18:31:28","modified_gmt":"2017-10-09T17:31:28","slug":"precon-performance-analysis-tuning-techniques-at-sqlsaturday-in-istanbul","status":"publish","type":"post","link":"https:\/\/andreas-wolter.com\/en\/precon-performance-analysis-tuning-techniques-at-sqlsaturday-in-istanbul\/","title":{"rendered":"PreCon Performance Analysis &#038; Tuning Techniques at SQLSaturday in Istanbul"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_heading-8006d928b0207af027eb4b7cef501a88\">\n#top .av-special-heading.av-av_heading-8006d928b0207af027eb4b7cef501a88{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-av_heading-8006d928b0207af027eb4b7cef501a88 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-av_heading-8006d928b0207af027eb4b7cef501a88 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-av_heading-8006d928b0207af027eb4b7cef501a88 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\"  >PreCon Performance Analysis <span class='special_amp'>&amp;<\/span> Tuning Techniques at SQLSaturday in Istanbul<\/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>What a year: after as many as <a href=\"http:\/\/www.insidesql.org\/blogs\/andreaswolter\/2013\/06\/upcoming-sql-server-conferences-2013\" target=\"_blank\" rel=\"noopener\">3 SQLSaturdays (Denmark, Netherlands, Germany)<\/a> behind me, I will now also speak at <a href=\"http:\/\/sqlsaturday.com\/258\/eventhome.aspx\" target=\"_blank\" rel=\"noopener\">SQSaturday #258 in Istanbul<\/a>, Turkey. And after my first PreCon this year at the <a href=\"http:\/\/sqlsaturday.com\/230\/\" target=\"_blank\" rel=\"noopener\">SQLSaturday<\/a> in Germany, which I was co-presenting together with Mladen Prajdi\u0107, on the part \u201cXEvents\u201d, I will now be giving a full day PreCon on \u201cPerformance Analysis &#038; Tuning Techniques\u201d!<!--more--><\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-c40d0c327dd0f01fbe64d7ce6402b381\">\n.avia-image-container.av-av_image-c40d0c327dd0f01fbe64d7ce6402b381 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-c40d0c327dd0f01fbe64d7ce6402b381 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-c40d0c327dd0f01fbe64d7ce6402b381 av-styling- avia-align-center  avia-builder-el-2  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-2894 avia-img-lazy-loading-not-2894 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1308_SQLSaturday258_Istanbul_Speaking.png\" alt='' title='1308_SQLSaturday258_Istanbul_Speaking'  height=\"115\" width=\"147\"  itemprop=\"thumbnailUrl\"  \/><\/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>I am really excited about the topic and location at the same time. <a href=\"http:\/\/en.wikipedia.org\/wiki\/Istanbul\" target=\"_blank\" rel=\"noopener\">Istanbul<\/a> is a must-see city for history- &#038; photography enthusiasts like me. (My Facebook wall is awaiting great images \ud83d\ude42<\/p>\n<p>Back to the technical stuff. Here is the session description &#038; agenda:<\/p>\n<p>\u201cBe ready for a full day of diving into SQL Server Performance Analysis. This session is focused on tools and techniques and how to resolve common problems. We will start on Operating System level using Perfmon and advance into SQL Server Wait Stats analysis for identifying bottlenecks. We will use different tools like SQL Trace &#038; Profiler and the successor: Extended Events for detailed analysis and see what other tools are available from codeplex. We will examine the Plan cache and Indexing using DMVs and finally get into locking &#038; concurrency problems. Expect lots of demos and a deep dive into core concepts of SQL Server.\u201d<\/p>\n<p>Included Topics:<\/p>\n<ul>\n<li>Performance Monitor for Server-Level Performance Analysis<\/li>\n<li>Wait-Stats Methology<\/li>\n<li>SQL Trace &#038; Profiler to Extended Events for Workload &#038; Query-Analysis<\/li>\n<li>Tempdb Performance Optimization<\/li>\n<li>Plan-Cache Analysis<\/li>\n<li>Index &#038; Statistics, Analysis &#038; Tuning<\/li>\n<li>Locking &#038; Blocking Analysis \/ Concurrency problems<\/li>\n<\/ul>\n<p>And here is the link to the PreCon registration: <a href=\"http:\/\/www.eventbrite.com\/event\/7619115981\" target=\"_blank\" rel=\"noopener\">www.eventbrite.com\/event\/7619115981<\/a><\/p>\n<p>If you want to combine a weekend in a city of history and beauty, with some deep-dive SQL Server topics, come and join us \ud83d\ude42<\/p>\n<p>Besides the PreCon I will also hold a presentation on Saturday \u2013 it might be on \u201cSecurity\u201d if rumors are right \ud83d\ude09 (not public yet).<\/p>\n<p>See you in Istanbul.<\/p>\n<p>Andreas<\/p>\n<\/div><\/section>\r\n\r\n<div  class='hr av-av_hr-0ff602b3e980a3377077ff3c1c834df6 hr-default  avia-builder-el-4  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-5  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\/precon-performance-analysis-tuning-techniques-at-sqlsaturday-in-istanbul\/&#038;t=PreCon%20Performance%20Analysis%20%26%20Tuning%20Techniques%20at%20SQLSaturday%20in%20Istanbul\" 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=PreCon%20Performance%20Analysis%20%26%20Tuning%20Techniques%20at%20SQLSaturday%20in%20Istanbul&#038;url=https:\/\/andreas-wolter.com\/en\/?p=2898\" 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=PreCon%20Performance%20Analysis%20%26%20Tuning%20Techniques%20at%20SQLSaturday%20in%20Istanbul&#038;url=https:\/\/andreas-wolter.com\/en\/precon-performance-analysis-tuning-techniques-at-sqlsaturday-in-istanbul\/\" 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":"What a year: after as many as 3 SQLSaturdays (Denmark, Netherlands, Germany) behind me, I will now also speak at SQSaturday #258 in Istanbul, Turkey. And after my first PreCon this year at the SQLSaturday in Germany, which I was co-presenting together with Mladen Prajdi\u0107, on the part \u201cXEvents\u201d, I will now be giving a [&hellip;]","protected":false},"author":4,"featured_media":2894,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[97,43,64,56],"tags":[24,178,101,65,179],"class_list":["post-2898","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-conferences-en","category-performance","category-sqlpass-en","category-tracing-monitoring-en","tag-conference-en","tag-performance-analysis_tuning-en","tag-precon-en","tag-sqlpass-en","tag-sqlsaturday-en"],"_links":{"self":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/2898","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=2898"}],"version-history":[{"count":2,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/2898\/revisions"}],"predecessor-version":[{"id":2899,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/2898\/revisions\/2899"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media\/2894"}],"wp:attachment":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media?parent=2898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/categories?post=2898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/tags?post=2898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}