{"id":6775,"date":"2025-03-11T18:05:35","date_gmt":"2025-03-11T23:05:35","guid":{"rendered":"https:\/\/andreas-wolter.com\/?p=6775"},"modified":"2025-03-11T18:13:51","modified_gmt":"2025-03-11T23:13:51","slug":"2502-sqlsaturday-nyc-precon-performance-monitoring-sqlserver","status":"publish","type":"post","link":"https:\/\/andreas-wolter.com\/en\/2502-sqlsaturday-nyc-precon-performance-monitoring-sqlserver\/","title":{"rendered":"PreCon Practical Performance Monitoring SQL Server at SQLSaturday New York City 2025 May 9th"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-m0cxh8ps-8a1aa34dfdb2f2c4b3519ad803cdf357\">\n#top .av-special-heading.av-m0cxh8ps-8a1aa34dfdb2f2c4b3519ad803cdf357{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-m0cxh8ps-8a1aa34dfdb2f2c4b3519ad803cdf357 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-m0cxh8ps-8a1aa34dfdb2f2c4b3519ad803cdf357 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-m0cxh8ps-8a1aa34dfdb2f2c4b3519ad803cdf357 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 Practical Performance Monitoring SQL Server at SQLSaturday New York City 2025 May 9th<\/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-m0cxgkjy-c935304b4106b45214698f40e83a9894 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>I am super excited to share that I\u2019ll be leading the PreCon session &#8220;<strong>Practical Performance Monitoring for SQL Server<\/strong>&#8221; on May 9<sup>th<\/sup> for <strong>SQL Saturday New York City 2025<\/strong> taking place the day after! Join us at the Microsoft Office in Times Square for an incredible event!<\/p>\n<p>This is only the second time since I left Microsoft that I will deliver this training day, but the first time in the US (Germany was first in October 2024).<\/p>\n<p>What makes my training day unique is that attendees will have the chance to connect to my demo server using SQL Server Management Studio and conduct their own analyses with T-SQL if they wish, and bring their own devices\/Laptops with SSMS installed.<\/p>\n<p style=\"padding-left: 40px;\">The server will be accessible via the internet and will be running a full-day workload filled with various performance issues. None of that \u201csorry, but you know, it\u2019s just a demo server and has no workload\u201d.<\/p>\n<p>Of course this is totally optional. Feel free to just sit back and enjoy the session.<\/p>\n<h3>Get your tickets here:<\/h3>\n<p><a href=\"https:\/\/www.eventbrite.com\/e\/practical-performance-monitoring-troubleshooting-sql-server-tickets-1230431316189\" target=\"_blank\" rel=\"noopener\">https:\/\/www.eventbrite.com\/e\/practical-performance-monitoring-troubleshooting-sql-server-tickets-1230431316189<\/a><\/p>\n<p><strong>Use this code for a 20% discount (USD50):<\/strong> <strong>LastChanceForEarlyBirdDiscountSQL<\/strong><\/p>\n<p>Here is the session abstract:<\/p>\n<h2><strong>Practical Performance Monitoring SQL Server<\/strong><\/h2>\n<p>You are in a DBA, developer or consultant role, supporting SQL Server databases and often someone asks you to take a look at a badly performing database application, certain queries or even \u201cthe whole server\u201d. And over and over again you find yourself in the situation of \u201chow to find the root cause in the least amount of time\u201d.<\/p>\n<p>This full-day precon with Andreas Wolter, a former Program Manager for SQL Server at Microsoft, will teach you techniques for general troubleshooting and performance analysis from start-up to advanced techniques.<\/p>\n<p>Among them are:<\/p>\n<ul>\n<li>SQL Server architecture &#038; internals \u2013 the fundament to understanding correlations<\/li>\n<li>Monitoring methodology, tools &#038; techniques\n<ul>\n<li>Windows Performance Monitor<\/li>\n<li>Dynamic Management Views (DMVs)<\/li>\n<li>Wait statistics<\/li>\n<li>Extended Events for workload &#038; query-analysis<\/li>\n<li>Query Store<\/li>\n<li>Azure SQL database watcher (intro)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>The above techniques will be used to:<\/p>\n<ul>\n<li>Identify the most impactful problematic queries<\/li>\n<li>Detect I\/O latency problems<\/li>\n<li>Investigate Tempdb performance<\/li>\n<li>Analyze indexes &#038; statistics<\/li>\n<li>Analyze locking &#038; blocking and concurrency problems<\/li>\n<li>Identify query plan regression<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6827\" src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2025\/03\/Banner-SQL-Perf-Analysis.jpg\" alt=\"\" width=\"855\" height=\"530\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2025\/03\/Banner-SQL-Perf-Analysis.jpg 855w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2025\/03\/Banner-SQL-Perf-Analysis-300x186.jpg 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2025\/03\/Banner-SQL-Perf-Analysis-768x476.jpg 768w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2025\/03\/Banner-SQL-Perf-Analysis-705x437.jpg 705w\" sizes=\"auto, (max-width: 855px) 100vw, 855px\" \/><\/p>\n<p>While no one has evolved into a performance-tuning-master in one single day, you can be sure to learn valuable techniques and concepts to build upon for day-to-day work. And of course, we will also discuss possible solutions or even implement them live. So, at your next phone call \u201cHelp, the server is slow!\u201d you know will where to start.<\/p>\n<p>Expect lots of demos and a deep dive into core concepts of SQL Server.<\/p>\n<p>Hands-on! \u2013 Attendees who want to directly try out some of the techniques shown can connect to the demo-server which is under a constant workload simulation live with SQL Server management studio themselves! (All that is required is to bring a laptop with SSMS installed and ability to connect to a SQL Server on the internet on a given port.)<\/p>\n<h3>Prerequisites<\/h3>\n<p>Basic understanding of the SQL Server relational engine and Transact-SQL, basic familiarity with Dynamic Management Views (DMVs) and query plans<\/p>\n<p>If you wish to connect to my server for running your own scripts, please bring your own device.<\/p>\n<h3>And here is the link for Signup again:<\/h3>\n<p><a href=\"https:\/\/www.eventbrite.com\/e\/practical-performance-monitoring-troubleshooting-sql-server-tickets-1230431316189\" target=\"_blank\" rel=\"noopener\">https:\/\/www.eventbrite.com\/e\/practical-performance-monitoring-troubleshooting-sql-server-tickets-1230431316189<\/a><\/p>\n<\/div><\/section>\r\n\r\n<div  class='hr av-baku8u-c77559299fb7cb036a9bcb2d27e7c839 hr-default  avia-builder-el-2  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-5n5vpa-78ffdd9d224b4a246af65bdc00dce900 av-social-sharing-box-default  avia-builder-el-3  el_after_av_hr  el_before_av_hr  av-social-sharing-box-fullwidth'><div class=\"av-share-box\"><h5 class='av-share-link-description av-no-toc '>Share article<\/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\/2502-sqlsaturday-nyc-precon-performance-monitoring-sqlserver\/&#038;t=PreCon%20Practical%20Performance%20Monitoring%20SQL%20Server%20at%20SQLSaturday%20New%20York%20City%202025%20May%209th\" 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%20Practical%20Performance%20Monitoring%20SQL%20Server%20at%20SQLSaturday%20New%20York%20City%202025%20May%209th&#038;url=https:\/\/andreas-wolter.com\/en\/?p=6775\" 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%20Practical%20Performance%20Monitoring%20SQL%20Server%20at%20SQLSaturday%20New%20York%20City%202025%20May%209th&#038;url=https:\/\/andreas-wolter.com\/en\/2502-sqlsaturday-nyc-precon-performance-monitoring-sqlserver\/\" 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\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-4ofg9q-c2108540b480aba02923089240a3a176\">\n#top .hr.hr-invisible.av-4ofg9q-c2108540b480aba02923089240a3a176{\nheight:50px;\n}\n<\/style>\n<div  class='hr av-4ofg9q-c2108540b480aba02923089240a3a176 hr-invisible  avia-builder-el-4  el_after_av_social_share  el_before_av_comments_list '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n<div  class='av-buildercomment av-284ftq-f5a1564cd6b8ffad6ce835e2d40de4b7  av-blog-meta-author-disabled av-blog-meta-html-info-disabled'><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":4,"featured_media":6827,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[97,55,43,56],"tags":[24,18,19],"class_list":["post-6775","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-conferences-en","category-extended-events-en","category-performance","category-tracing-monitoring-en","tag-conference-en","tag-extended-events-en","tag-performance-analysis-en"],"_links":{"self":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/6775","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=6775"}],"version-history":[{"count":5,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/6775\/revisions"}],"predecessor-version":[{"id":6830,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/6775\/revisions\/6830"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media\/6827"}],"wp:attachment":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media?parent=6775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/categories?post=6775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/tags?post=6775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}