Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add trace flag 876 #151

BrentOzar opened this issue Sep 25, 2018 · 1 comment

Add trace flag 876 #151

BrentOzar opened this issue Sep 25, 2018 · 1 comment


Copy link

@BrentOzar BrentOzar commented Sep 25, 2018

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.

@ktaranov ktaranov self-assigned this Sep 25, 2018
Copy link

@ktaranov ktaranov commented Sep 25, 2018

@BrentOzar Great thanks for this trace flag,
added via 7fc8ce4

Waiting for Niko answer to add more information and use cases.


@ktaranov ktaranov closed this Jan 24, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants