SQL Server Internals for Performance Tuning provides the internal details you need to know to make sure you can get the best performance from your SQL Server.
This is an advanced course designed for advanced SQL Server professionals. The course includes extensive demonstrations that illustrate the details of SQL Server internals. This course will be presented on SQL Server 2017 and cover features specific to that version, but most of the information is relevant to SQL Server 2016 and SQL Server 2014, and some is relevant to earlier versions.
Topics to be covered include:
- SQL Server Storage Metadata
- Tools for exploring storage structures
- Physical Storage Structures
- Query Processing and Query Plans
- Optimization and Recompilation
- Index Design and Tuning
- Statistics Internals and Management
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 – after your class finishes, you can stream the online recordings for a year. 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 currently scheduled for another live delivery in 2018. You can purchase the Instant Replay and start watching the recorded version right away, and if another date is scheduled, you’ll automatically be enrolled in that class at no additional charge.