Module 1: SQL Server Architecture, Scheduling, and Waits
- SQL Server Components and SQL OS
- Windows Scheduling vs SQL Scheduling
- Waits and Queues
Module 2: SQL Server I/O
- I/O Setup and Testing
- Core Concepts
- Storage Solutions
Module 3: Database Structures
- Data File Internals
- Database Structure Internals
- TempDB Internals
Module 4: SQL Server Memory
- SQL Server Memory
- In-Memory OLTP
- Windows Memory
Module 5: SQL Server Concurrency
- Concurrency and Transactions
- Locking Internals
Module 6: Statistics and Index Internals
- Index Internals
- Columnstore Indexes
- Statistics Internals and Cardinality Estimation
Module 7: Query Execution and Query Plan Analysis
- Analyzing query execution plans
- Adaptive query processing
- Query execution and optimizer internals
- Query execution plans
Module 8: Plan Caching and Recompilation
- Automatic tuning
- Query store
- Plan cache internals
- Troubleshooting plan cache issues
Module 9: Extended Events
- Extended events core concepts
- Working with extended events
Module 10: Monitoring, Tracing, and Baselining
- Baselining and benchmarking
- Monitoring and tracing