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