-
Notifications
You must be signed in to change notification settings - Fork 723
Closed
Labels
Description
From Slava Oks' tweet this week on SQL Server 2019:
With every new #SQLServer announcement it feels like Christmas time of the year, presents for everyone, @NikoNeugebauer with #SQLServer2019 CTP 2.0, could you please try trace flag -T876 instead of -T834 for some of key CS scenarios and check performance?
No -T876 is different beast... it turns 8k page allocations for CS segments into 2MB instead. -T834 does exactly that as well as it pre-commits the entire sql memory with large pages which many workloads don’t really need.
Reactions are currently unavailable