SQL Server Query Slow Check These 5 Things First
DevLab
0:00 / 0:00
SQL Server Query Slow Check These 5 Things First
78 просмотров · 2 недели назад
DevLab
62 подписчика
78 просмотров · 2 недели назад
Your SQL query is slow — but rewriting it may not be the fix.
In this hands-on SQL Server demo, I check five signals before changing the query or adding an index: the actual execution plan, logical reads, SARGability, estimated versus actual rows, and blocking/waits.
This video is aimed at .NET developers, backend engineers, DB-focused developers, and architects who need a practical way to diagnose SQL Server performance problems.
Chapters
00:09 — The wrong thing to check
00:17 — The 5-check workflow
01:00 — Why a slow query has multiple causes
01:21 — How SQL Server turns query text into work
01:53 — Check 1: Actual execution plan
02:19 — Check 2: Logical reads
04:47 — Check 3: SARGability
06:16 — Check 4: Estimated vs actual rows
09:10 — Check 5: Blocking
10:11 — The catch: don’t fix the symptom
10:53 — Evidence → diagnosis → change
11:25 — The architect’s view
11:55 — Three takeaways
12:32 — What do you check first?
Covered in this video
SQL Server execution plans, STATISTICS IO, STATISTICS TIME, logical reads, SARGable predicates, index usage, cardinality estimates, estimated versus actual rows, blocking sessions, waits, and practical query tuning.