Debugging SQL Server
summary
Shows how the product team reproduces and diagnoses real crashes and hangs using concrete tools: loading mdmp files with the Windows Debugger, running dot ecxr to get the exact faulting instruction, and using SQL dumper.exe and built‑in unit tests to force access violations or non‑yielding schedulers. Covers defensive features like trace flag 815 (buffer latch enforcement), the scheduler monitor that spawns dumps on long non‑yields, XEvent/system_health for live diagnostics, spin‑lock backoff metrics and the partitioning fix that collapsed heavy hash‑bucket contention.
AI-written summary · about
chapters (11)
- 0:00Introduction
- 2:20Debugging fundamentals
- 4:04Access violations
- 10:56Debugging tools demo
- 21:55Handling server hangs
- 26:43Analyzing non-yielding
- 35:12Thread pool issues
- 37:19Preemptive waits
- 40:02Spinlock debugging
- 45:22Advanced performance case
- 48:28Q&A and conclusion
related talks
18mApparently, you can "debug" your SQL queries
49mHidden Gems in SQL Server 2022 Database Engine
52mDetecting Malicious Activity: Unveiling the Secrets of MS-SQL Logging
53mSQL Server Internals: The Practical Angle
01h 02mUnlocking the Full Potential: The Harmonious Dance of EF Core and SQL Server
56mEntity Framework debugging using SQL Server: A Detective Story
23mShift-Left: A DevOps and Database Story
50mDistributed Replay Testing with Your Data, Your Way!