Autoplay
Autocomplete
Previous Lecture
Complete and continue
Fundamentals of TempDB
Before the Class
Prerequisites
Introductions and Overview (3:07)
Download the Slide Decks & Scripts
Fundamentals of TempDB
How the Version Store Affects TempDB (26:59)
How Temp Tables Are Different from Regular Tables (63:51)
How Table Variables Can Be Better Than Temp Tables (21:07)
Temp Tables & Table Variables at Scale: PFS/GAM/SGAM Contention (55:23)
How Memory-Optimized Table Variables Reduce Contention (12:17)
How Execution Plans Use TempDB (20:19)
Other TempDB Consumers: Cursors, Index Builds, AG Statistics (19:07)
Limiting TempDB Usage with Resource Governor (21:01)
How to Provision and Monitor TempDB (15:59)
Other TempDB Consumers: Cursors, Index Builds, AG Statistics
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock