We’re going to start the class by talking about things that use TempDB. First up are a pair of my favorite features: Read Committed Snapshot Isolation (RCSI) and Snapshot Isolation (SI) help you quickly mitigate blocking problems. Readers don’t block writers, and writers don’t block readers. It’s also known as optimistic concurrency or multi-version concurrency…
1 – How the Version Store Affects TempDB
We’re going to start the class by talking about things that use TempDB. First up are a pair of my favorite features: Read Committed Snapshot Isolation (RCSI) and Snapshot Isolation (SI) help you quickly mitigate blocking problems. Readers don’t block writers, and writers don’t block readers. It’s also known as optimistic concurrency or multi-version concurrency…
To access this incredible, amazing content, you gotta get Recorded Class Season Pass or Fundamentals of TempDB, or log in if you already shelled out the cash.
- 0 – Prerequisites Before the Class
- 2 – How Temp Tables Affect TempDB
- 3 – How Table Variables Affect TempDB
- 4 – Temp Tables and Table Variables at Scale: PFS/GAM/SGAM Contention
- 5 – Memory-Optimized Table Variables
- 6 – How Execution Plans Use TempDB
- 7 – Other TempDB Consumers: Cursors, Index Builds, AG Stats
- 8 – How to Provision and Monitor TempDB