Fundamentals of TempDB
What uses it, how that affects performance, and how to monitor it.
Fundamentals
What you will get:
- Watch on any Device
- 2 sections
- lectures
- of video
Last updated: 30 June 2022
Your Instructor
I make Microsoft SQL Server go faster. I've been working with SQL Server since the late 1990s, and I'm one of the rare Microsoft Certified Masters of SQL Server. I love teaching, travel, and laughing. I live in Las Vegas, Nevada.
Course Description
You want to learn how to troubleshoot temp table plan reuse, the version store, latch contention, and where to put the files. Learn in this recorded class. (This is not a live class - if you want to attend live, check out my Live Class Season Pass.)
Want to save a bundle? This class is included in my Recorded Class Season Pass: Fundamentals bundle.
Course Curriculum
Before the Class
Available in
days
days
after you enroll
Fundamentals of TempDB
Available in
days
days
after you enroll
- How the Version Store Affects TempDB (23:45)
- How Temp Tables Are Different from Regular Tables (27:31)
- How Table Variables Can Be Better Than Temp Tables (15:41)
- Temp Tables & Table Variables at Scale: PFS/GAM/SGAM Contention (21:14)
- How Memory-Optimized Table Variables Reduce Contention (19:20)
- How Execution Plans Use TempDB (26:53)
- Other TempDB Consumers: Cursors, Index Builds, AG Statistics (20:12)
- How to Provision and Monitor TempDB (19:24)