Problem page
SQL Server blocking problems
Use this when waiting chains, lock pressure, or head blockers are already hurting production and the team needs a faster diagnosis path.
MKsql server / performance-blocking-concurrency
Performance, blocking, and concurrency
Blocking, deadlocks, waits, indexing, and the deeper reading behind real production performance work.
Start here when the pain is slowness, lock pressure, unstable workload behavior, or diagnosis that keeps bouncing between symptoms without reaching a root cause.
Problem page
SQL Server deadlock problems
Use this when victims keep showing up, transactions overlap badly, and the team needs a cleaner path than killing sessions and hoping.
Problem page
SQL Server slow performance
Use this when the system is just slow enough to hurt work, but the root cause is still fuzzy and every quick guess points somewhere else.
Live guides
Guides that carry the deeper operational detail
Some of these pages still live under /hub. What matters here is that they read as one working lane instead of a flat list of disconnected SQL topics.
SQL Server blocking guide
Blocking chains, head blockers, transaction scope, and the production-safe path to diagnosing recurring contention.
SQL Server deadlocks guide
Deadlock capture, transaction overlap, indexing causes, and the concurrency patterns behind repeated deadlock victims.
SQL Server indexing guide
Access-path review, write tradeoffs, and workload-based indexing decisions instead of tuning folklore.
SQL Server waits guide
How to read SQL Server wait patterns more usefully, separate signal from noise, and connect waits back to workload behavior.
Service paths
Service paths that match this kind of SQL work
Incident and stabilization
SQL Server performance review
Performance and concurrency review for blocking, deadlocks, broad slowness, and unstable workload behavior.
Audit and health review
SQL Server health audit
Practical review for inherited estates, weak operational ownership, and environments that need a real fix order.