Performance Tuning and Optimizing SQL Databases

Performance Tuning and Optimizing SQL Databases

• Module 1: SQL Server Architecture, Scheduling, and Waits • Module 2: SQL Server I/O • Module 3: Database Structures • Module 4: SQL Server Memory • Module 5: SQL Server Concurrency • Module 6: Statistics and Index Internals • Module 7: Query Execution and Query Plan Analysis • Module 8: Plan Caching and Recompilation • Module 9: Extended Events • Module 10: Monitoring, Tracing, and Baselining