Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Support Trace Flag 834 with Columnstore

Trace flag 834 has been marked as unsupported with columnstore by Microsoft since SQL Server 2012, but that trace flag resolves columnstore and batch mode related bottlenecks with the RESERVED_MEMORY_ALLOCATION_EXT wait when running workloads at high concurrency. In addition, vendors use TF 834 with columnstore when competing in the TPC-H benchmarks.

Please support TF 834 with columnstore.

References with reproducible workloads:

https://orderbyselectnull.com/2018/03/06/large-cci-etls-cannot-scale-without-tf-834/

11 votes
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)

We’ll send you updates on this idea

Joe Obbish shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base