SQL Server 2022: System Page Latch Concurrency Enhancements (Ep. 6) | Data Exposed

[@mrfuzztone]

Is there a link to information on the script used by David Pless to test the contention and the diagnostic query? I didn't hear it mentioned what was causing the contention in the test script. Maybe I missed it. Temp tables, sorts, other ?

[@SanataniHindu5165]

Thanks Anna and David for sharing this video. 👏

[@TheGodFatherItalian]

Hello Anna. Hope you are well. We are running SQL Server 2016 SP3 with multiple TEMPDB files. We are seeing GAM contention on one of the many TEMPDB files. Why isn't the engine using the GAM within each TEMPDB file for this particular process? I heard there was a bug in the SP for this version of SQL Server.

[@mrfuzztone]

are all the tempdb files equal size?

[@davidlean8674]

Maybe SQL2022 has reduced the benefit of having many files on the same drive. But there is still a benefit to having many files spread over many windows filesystems (drive letters). Even if they all blend back into the same switch fabric & data store.