Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Fundamentals of TempDB
Before the Class
Prerequisites
Introductions and Overview (8:59)
Download the Slide Decks & Scripts
Fundamentals of TempDB
How the Version Store Affects TempDB (41:36)
How Temp Tables Are Different from Regular Tables (37:22)
How Table Variables Can Be Better Than Temp Tables (26:09)
Temp Tables & Table Variables at Scale: PFS/GAM/SGAM Contention (43:02)
How Memory-Optimized Table Variables Reduce Contention (30:12)
How Execution Plans Use TempDB (40:14)
Other TempDB Consumers: Cursors, Index Builds, AG Statistics (20:00)
How to Provision TempDB on a New Server (25:08)
How to Monitor TempDB on an Existing Server (5:32)
How Memory-Optimized Table Variables Reduce Contention
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock