Inside Tempdb

Dive deep into the internals of the tempdb database in this advanced 2-hour 43-minute conference talk from PASS Data Community Summit. Explore frustrating, least understood, and contentious areas of the SQL Server Engine with a focus on tempdb. Gain practical knowledge and advice to avoid problems and maximize tempdb usage through an in-depth examination of memory structures, classes, and bitmaps. Utilize tools like the Windows Debugger, DMVs, DBCC commands, and possibly hex editors to unravel the complexities of this critical database component. Be prepared for a fast-paced, information-rich 500-level session that will enhance your understanding of SQL Server's tempdb, regardless of your current expertise level.

Inside Tempdb - Bob Ward