Страница 1 из 1

SQL2022: Tempdb enhancement

Добавлено: 25.07.2022 14:03:38
komrad
... 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
https://cloudblogs.microsoft.com/sqlser ... rver-2022/