Performance Tuning and Optimizing SQL Databases
- Overview: Performance Tuning and Optimizing SQL Databases
- Overview: SQL Server Architecture, Scheduling, and Waits
- Lesson 1: SQL Server Components and SQLOS
- Lesson 2: Windows Scheduling vs. SQL Server Scheduling
- Lesson 3: Waits and Queues
- Lab 1: SQL Server Architecture, Scheduling, and Waits
- Overview: SQL Server I/O
- Lesson 1: Core Concepts of I/O
- Lesson 2: Storage Solutions
- Lesson 3: I/O Setup and Testing
- Lab 2: Testing Storage Performance
- Overview: Database Structures
- Lesson 1: Database Structure Internals
- Lesson 2: Data File Internals
- Lesson 3: tempdb Internals
- Lab 3: Database Structures
- Overview: SQL Server Memory
- Lesson 2: SQL Server Memory
- Lesson 1: Windows Memory
- Lesson 3: In-Memory OLTP
- Lab 4: SQL Server Memory
- Overview: SQL Server Concurrency
- Lesson 1: Concurrency and Transactions
- Lesson 2: Locking Internals
- Lab 5: Concurrency and Transactions
- Overview: Statistics and Index Internals
- Lesson 1: Statistics Internals and Cardinality Estimation
- Lesson 2: Index Internals
- Lesson 3: Columnstore Indexes
- Lab 6: Statistics and Index Internals
- Overview: Query Execution and Query Plan Analysis
- Lesson 1: Query Execution and Query Optimizer Internals
- Lesson 2: Query Execution Plans
- Lesson 3: Analyzing Query Execution Plans
- Lab 7: Query Execution and Query Plan Analysis
- Overview: Plan Caching and Recompilation
- Lesson 1: Plan Cache Internals
- Lesson 2: Troubleshooting with the Plan Cache
- Lesson 3: Query Store
- Lab 8: Plan Caching and Recompilation
- Overview: Extended Events
- Lesson 1: Extended Events Core Concepts
- Lesson 2: Working with Extended Events
- Lab 9: Extended Events
- Overview: Monitoring, Tracing, and Baselines
- Lesson 1: Monitoring and Tracing
- Lesson 2: Baselining and Benchmarking
- Lab 10: Monitoring, Tracing, and Baselining