Answer
TempDB contention occurs when multiple threads compete for the same allocation pages (PFS, GAM, SGAM) or metadata structures.
Typical causes include:
- Too few TempDB data files
- Heavy use of temp tables/table variables
- Large sorting or hashing operations
- High row versioning pressure
Fixes: increase file count, equal-size files, optimize workload, reduce spills.