4

Has anyone encountered trace flag 8041 in the wild, and can you explain what it does?

I inherited a SQL Server 2016 (13.0.5865.1) and there are some trace flags enabled. One of them is 8041. I've searched online but haven't find any thing.

Keep in mind these are databases that are migrated from, SQL Server 2005 => 2008 R2 => 2016, long before I came along. So it might be something from 2005. Or it might be nothing, but I would like to know the impact before disabling it.

2
  • Could you please put code sample where this trace is used and have you tried comparing the execution plan and other details with the traceflag and without it? Feb 1 at 9:59
  • The trace is on globally Feb 1 at 10:14

2 Answers 2

6

This trace flag existed for a brief moment in time but hasn't existed since. It was originally implemented in CTP 5 and 6 for Katmai (2008) and never documented. It was then removed and has been a no-op since.

While it might be listed in books or blogs, trace flags can and do change. Many are version dependent and some stay, but change, even across versions (look at 4199 for example).

This TF currently does nothing since the CTP days.

3

Taken from Beginning Microsoft SQL Server 2008 Administration by Chris Leiter, Dan Wood, Michael Cierkowski, Albert Boettger:-

The following code shows how to re-set the Resource Governor statistics that are reported by the resource pool and workload group management views. You may want to do this after making significant configuration changes to the Resource Governor.

DBCC TRACEON (8041, -1)
GO
ALTER RESOURCE GOVERNOR RECONFIGURE

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.