{"id":4543,"date":"2015-08-08T10:14:14","date_gmt":"2015-08-08T17:14:14","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/paul\/?p=4543"},"modified":"2015-08-08T10:14:14","modified_gmt":"2015-08-08T17:14:14","slug":"my-upcoming-sessions-at-pass-and-sqlintersection","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/","title":{"rendered":"My upcoming sessions at PASS and SQLintersection"},"content":{"rendered":"<p>The two major Fall conferences (PASS Summit and SQLintersection) are\u00a0coming up in October\u00a0so I wanted to give you a heads-up about what I&#8217;ll be presenting.<\/p>\n<p>The workshop I&#8217;ll be doing at both conferences\u00a0is based on\u00a0one of\u00a0my favorite topics \u2013 wait statistics and using them for performance troubleshooting. I\u2019m very passionate about helping people learn about wait statistics and how to use them *correctly* as an invaluable aid when troubleshooting performance problems in SQL Server. You may have seen one of my user group sessions over the year where I&#8217;ve talked about wait stats for 60-90 minutes, but here\u00a0I\u2019ll have an entire day to expand into techniques for further troubleshooting, rather\u00a0than just evaluating the wait and latch statistics themselves.<\/p>\n<p>The no-frills title of the workshop is:\u00a0<strong>Performance Troubleshooting Using Waits and Latches<\/strong><\/p>\n<p>Here\u2019s the abstract:<\/p>\n<p><em>One of the first things you should check when investigating performance issues are wait and latch statistics, as these can often point you in the right direction for further analysis. Unfortunately many people misinterpret what SQL Server is telling them and jump to conclusions about how to solve the problem \u2013 what is often called \u2018knee-jerk performance tuning\u2019. In this full-day workshop, you\u2019ll learn how to investigate and interpret wait and latch statistics \u2013 practical techniques you can take home and start using immediately. You\u2019ll also learn what a myriad of wait and latch types actually mean and how you can investigate lightly-documented types to gain insight into what causes them. Don\u2019t waste time when it comes to performance troubleshooting; wait statistics are the fastest route to understanding your problems and this workshop will help you get there faster.<\/em><\/p>\n<p>If you come along I promise you that you\u2019ll learn a ton of really, really useful information and techniques \u2013 I\u2019m looking forward to teaching it tremendously.<\/p>\n<p>You can get more details about this year\u2019s <strong>PASS Summit in Seattle, October\u00a027-30<\/strong>\u00a0at <a href=\"http:\/\/www.sqlpass.org\/summit\/2015\/Welcome.aspx\" target=\"_blank\">this website<\/a>.<\/p>\n<p>You can get more details about this year\u2019s <strong>Fall SQLintersection in Las Vegas, October 26-29<\/strong>\u00a0at <a href=\"https:\/\/devintersection.com\/SQL-Conference\/\" target=\"_blank\">this website<\/a>.<\/p>\n<p>Yes, unfortunately both conferences are unavoidably on the\u00a0same week, which means some creative flying around the country on our part.<\/p>\n<p>Whichever conference you go to, I\u2019m looking forward to meeting you and I hope to see you in my workshop!<\/p>\n<p>Cheers<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The two major Fall conferences (PASS Summit and SQLintersection) are\u00a0coming up in October\u00a0so I wanted to give you a heads-up about what I&#8217;ll be presenting. The workshop I&#8217;ll be doing at both conferences\u00a0is based on\u00a0one of\u00a0my favorite topics \u2013 wait statistics and using them for performance troubleshooting. I\u2019m very passionate about helping people learn about [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,97],"tags":[],"class_list":["post-4543","post","type-post","status-publish","format-standard","hentry","category-conferences","category-training"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>My upcoming sessions at PASS and SQLintersection - Paul S. Randal<\/title>\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\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"My upcoming sessions at PASS and SQLintersection - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"The two major Fall conferences (PASS Summit and SQLintersection) are\u00a0coming up in October\u00a0so I wanted to give you a heads-up about what I&#8217;ll be presenting. The workshop I&#8217;ll be doing at both conferences\u00a0is based on\u00a0one of\u00a0my favorite topics \u2013 wait statistics and using them for performance troubleshooting. I\u2019m very passionate about helping people learn about [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-08T17:14:14+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\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\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/\",\"name\":\"My upcoming sessions at PASS and SQLintersection - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2015-08-08T17:14:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"My upcoming sessions at PASS and SQLintersection\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"My upcoming sessions at PASS and SQLintersection - Paul S. Randal","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\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/","og_locale":"en_US","og_type":"article","og_title":"My upcoming sessions at PASS and SQLintersection - Paul S. Randal","og_description":"The two major Fall conferences (PASS Summit and SQLintersection) are\u00a0coming up in October\u00a0so I wanted to give you a heads-up about what I&#8217;ll be presenting. The workshop I&#8217;ll be doing at both conferences\u00a0is based on\u00a0one of\u00a0my favorite topics \u2013 wait statistics and using them for performance troubleshooting. I\u2019m very passionate about helping people learn about [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/","og_site_name":"Paul S. Randal","article_published_time":"2015-08-08T17:14:14+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/","name":"My upcoming sessions at PASS and SQLintersection - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2015-08-08T17:14:14+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/my-upcoming-sessions-at-pass-and-sqlintersection\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"My upcoming sessions at PASS and SQLintersection"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=4543"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4543\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=4543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=4543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=4543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}