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