- Lab 1: Reviewing and Fixing Power Plan Configuration
Lab 2: Troubleshooting PAGEIOLATCH Wait Type
Lab 3: Capturing Wait Stats Using Extended Events
Lab 4: Proactive CPU Troubleshooting
Lab 5: Tracking Memory Consumption
Lab 6: Understanding Query Performance Issues Using Execution Plans (Common Plan Iterators/Operators)
Lab 7: Query Tuning – Fixing Implicit Conversion
Lab 8: Query Tuning – Fixing Non-SARGability
Lab 9: Index Tuning – Removing Bookmark Lookups
Lab 10: Index Tuning – Index for Joins
Lab 11: Fixing Deadlocks Part 1
Lab 12: Computing IO Latency
Lab 13: Tracking Tempdb Usage
Reviews
There are no reviews yet.