SQL2022: Tempdb enhancement

Всё о СУБД MS SQL.
Ответить
komrad
Сообщения: 5
Зарегистрирован: 03.06.2022 15:47:08

SQL2022: Tempdb enhancement

Сообщение 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/
Ответить