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.