Trace flag 2301, what does it do?

GokhanVarol 2013-02-28 14:25:13

Is there any explanation on what kind of workloads benefit from this trace flag, lot's of merge joins with lots of partitioned tables or?
Thank you

http://support.microsoft.com/kb/920093
Trace flag 2301: Enable advanced decision support optimizations

Trace flag 2301 enables advanced optimizations that are specific to decision support queries. This option applies to decision support processing of large data sets.

Aaron Bertrand 2013-03-01 15:33:34
Some suggested reading on this trace flag:

http://blogs.msdn.com/b/ianjo/archive/2006/04/24/582219.aspx

http://www.scarydba.com/tag/trace-flag-2301/

http://www.brentozar.com/archive/2008/10/before-you-upgrade-to-sql-server-2008/

Honestly I don't think there is a perfect workload that will always benefit from one trace flag or another. Too many variables – these are things where, if your workload suffers from the pain a trace flag is supposed to alleviate, you have to test. It might make it better, it might not.

GokhanVarol 2013-03-01 01:04:16
Thank you. I don't think our workload matches that but I will do some testing anyway.