SQL Server Internals: The Practical Angle
summary
Shows concrete internals: how forwarding pointers created by updates inflate storage and push rows off extents, how deleting 50 index entries produces blocking and measurable lock escalation, and which session flags trigger escalation into exclusive locks. Includes before/after numbers for storage and execution time, a demo of index rebuilds and statistic histogram changes, and which parameters (for example optimize for) actually change query plans and why a rebuild sometimes fixes but sometimes exposes new contention.
AI-written summary · about
chapters (11)
- 0:00Start
- 1:10Technical Assistance
- 5:58Separation of Duties (Dev vs. DBA)
- 6:53Pre-Con Goals
- 8:59Heap Tables
- 15:43DML Triggers
- 24:32Exclusive (X) Locks
- 25:09Shared (S) Locks
- 28:09Lock Escalation
- 35:16Plan Caching
- 51:46Like What You've Heard?
related talks
53mIndexing Internals for Developers & DBAs- 53mIndexing Internals for Developers & DBAs
- 53mIndexing Internals for Developers & DBAs
49mHidden Gems in SQL Server 2022 Database Engine
48mSQL Server 2022 hidden gems
47mMaximizing Database Performance With Isolation Levels- 49mHidden Gems in SQL Server 2022 Database Engine
48mA Deep Dive Into Database Internals