LyraLearn AI Learning Platform
Exams
← SQL Server Performance Tuning
Module 1

Measure First: Finding What's Actually Slow

Wait stats, query store, and extended events — find the real bottleneck before you touch anything.

1.1
"Where the Time Actually Goes"
10 min
1.2
"Query Store: Your First Stop"
12 min
1.3
"The DMVs Worth Knowing"
12 min
1.4
"Wait Statistics: What Is It Waiting On?"
12 min
1.5
"Establishing a Baseline You Can Prove Against"
10 min