Tempdb Latch Contention on SQL Server 2019 and 2025
Reproducing tempdb PAGELATCH contention with 48 sessions on SQL Server 2019 and 2025: which pages the waits hit, and how to name them.
Reproducing tempdb PAGELATCH contention with 48 sessions on SQL Server 2019 and 2025: which pages the waits hit, and how to name them.