SQL Intersection Autumn/Fall 2017 Day 1
30th October 2017
I’m over in Las Vegas for the SQL Intersection conference, I’m still trying to get over the Jet Lag with the -7 hour time difference. I wake up at 04:20 and try getting back to sleep with no luck, so on goes the TV and tuned into the Discovery Channel with back to back shows on till 06:30. I got ready and headed straight to registration which wasn’t open till 07:30.
I booked into Paul Randal’s pre-conference workshop on: Performance Troubleshooting using Waits and Latches. I’m posting the description just in case this changes in the future as I can’t see any history for past conferences.
SUNDAY 9AM – 4PM
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 – what is often called ‘knee-jerk performance tuning’. In this full-day workshop, you’ll learn how to investigate and interpret wait and latch statistics – practical techniques you can take home and start using immediately. You’ll 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’t 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.
The day is split up nicely. We started at 09:00 and finished only slightly over 16:00. There was a quick break between 09:00-12:00, Lunch was served at 12:00-13:00, and then another 2 quick breaks between 13:00-16:00. There was plenty of Tea, Coffee and water provided throughout the day.
Session content was exemplary, without going into to much detail Paul talked about Thread life-cycle, Waits and Latches, DMVs, Common wait and latch types and provided plenty of examples/demos. If you had any questions Paul was more than happy to answer them as you went along, I was particularity impressed with Paul being able to “translate” some terms into British English so I didn’t get lost.