SQL2022: Tempdb enhancement
Добавлено: 25.07.2022 14:03:38
https://cloudblogs.microsoft.com/sqlser ... rver-2022/... in SQL Server 2022 we allow concurrent updates to the GAM and SGAM under a shared latch rather than using the update latch. This improvement erases nearly all tempdb contention allowing parallel threads to be able to modify the GAM and SGAM pages