Product Description
You’re a developer or database administrator, and you’re curious.
You love learning about the internals of the tools you use. You’re comfortable writing queries and creating tables, but you don’t always understand why a particular index gets used, and another one does not. You’re not sure when SQL Server chooses to reuse an existing query plan, versus when it decides to create a new one.
You’ve been to a few 1-hour “how to tune indexes” or “how to tune queries” sessions at your local user group, SQLSaturdays, or online, and you’re ready to dig deeper. You’ve run common industry tools like sp_WhoIsActive, sp_BlitzIndex, and sp_BlitzCache, but now you want to learn where those tools get their data from.
You’re ready for SQL Server Internals 201.
This class includes extensive demonstrations that illustrate the details of SQL Server internals: metadata, physical storage, query processing, query plans, recompilation, plan cache management, and distribution statistics. This course is presented on SQL Server 2017, but the vast majority of content is relevant to earlier versions, too. To see the full list of modules, click the Modules and Agenda tab.
About the instructor: Kalen Delaney has been a Microsoft MVP for SQL Server since 1993. She is the author of several highly regarded books, including Microsoft SQL Server 2012 Internals, SQL Server Concurrency, SQL Server MVP Deep Dives, and SQL Server Internals of In-Memory OLTP.
This is an online class – Kalen hosts it in GoToWebinar, live on webcam, taking questions as she goes through the material. Audio can come through either your computer audio, or by dialing into a US phone number – headset recommended either way. For more information, check out the Training Logistics PDF for our online classes.
You can watch again later with Instant Replay – as soon as you register, you can stream the online recordings for a year. Watch early to get ready, then after your live class, brush up on stuff you missed or revisit your favorite topics. It’s the best of both worlds: live training with us, plus reminders.
This class is not scheduled for delivery, but you can contact Kalen Delaney to schedule a class at your company.
Lori Fry –
Kalen is a very good teacher and helped me understand the WHY of query processing, plans and indexes and then HOW to increase performance using what I learned. She gave us lots of useful tools/queries to see what the metadata looks like and the section on Plan Cache Management was eye opening. I’m using my new skill set to troubleshoot performance issues at work and sharing with my developers. I recommend this class to anyone who wants to learn more about performance tuning as a DBA or developer.