Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I did my 5 minute research and have not come up with a concise list, or even a list really except for Trace Flags (2012) which is a bit lacking.

Looking at this query which uses 8691, I was wondering if such a list exists.

with cte(guid,other) as ( 
select newid(),1 union all 
select newid(),2 union all 
select newid(),3) 
select a.guid, a.other, b.guid guidb, b.other otherb 
from cte a 
cross join cte b 
order by a.other, b.other 
OPTION (QUERYTRACEON 8691);
share|improve this question
    
The vast majority of Trace Flags are undocumented as they should not be used. They are there for advanced troubleshooting purposes by the SQL support team only. The link you found is valid for known and supported trace flags. –  Nic Oct 26 '12 at 21:31
    
antapex.org/traceflags_sqlserver.txt has a pretty good list. –  Max Vernon Oct 26 '12 at 23:40
    
lol I moticed that! –  Max Vernon Oct 27 '12 at 1:05

2 Answers 2

up vote 4 down vote accepted

http://antapex.org/traceflags_sqlserver.txt

Although this isn't complete, it is the biggest single list I know of.

This MSDN article lists the Query Optimizer Trace Flags necessary to support several changes to the QO in various QFEs and hotfixes, etc.

http://support.microsoft.com/kb/974006

Technet also has a list of various trace flags (probably already documented in the links above:

http://technet.microsoft.com/en-us/library/ms188396.aspx

This documents trace flag 610: http://msdn.microsoft.com/en-us/library/dd425070%28v=SQL.100%29.aspx (controls minimally logged inserts into indexed tables)

(more to come)

share|improve this answer
    
Came across another list here though I haven't cross referenced it against any of your other lists –  Martin Smith Nov 27 '12 at 10:03
1  
And another list here –  Martin Smith Feb 10 '13 at 17:40
    
Here Another list of Trace Flags: sqlservice.se/sv/start/blogg/… –  user24199 May 26 '13 at 12:38

The list of trace flags which you found on MSDN are the only flags which you should be running.

Anything which isn't documented is only supposed to be used by the developers and PSS when troubleshooting problems.

share|improve this answer
2  
Given the context of dba.se, don't you think it would help? Since when have developers stopped using something because it's undocumented!? –  孔夫子 Oct 27 '12 at 0:49
    
Denny's answer is important since it shows the importance of not over-using the flags. –  Max Vernon Oct 27 '12 at 4:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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