Перейти к содержимому

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.