Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server traceflags Expand / Collapse
Author
Message
Posted Thursday, December 13, 2012 12:41 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, December 4, 2015 3:51 PM
Points: 32, Visits: 335
Hi, does anyone know where on Microsoft site could we find a completed list of traceflags for SQL Server 2008 R2?

Thanks,
V
Post #1396019
Posted Thursday, December 13, 2012 1:35 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 6:58 AM
Points: 1,800, Visits: 10,250
The best resource is actually here, on SSC: http://www.sqlservercentral.com/articles/trace+flags/70131/. Otherwise you end up hunting in several areas to gather a comprehensive list.

Steve Hall
Linkedin
Blog Site
Post #1396050
Posted Thursday, December 13, 2012 2:36 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:13 PM
Points: 43,997, Visits: 41,388
There's no official list because many traceflags are undocumented or confidential. Microsoft is not going to go and document a list of undocumented traceflags


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1396063
Posted Thursday, December 13, 2012 2:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, December 4, 2015 3:51 PM
Points: 32, Visits: 335
Thanks BrainsDonor, the list looks perfect to me. Every flags I was searching today are on the list!

BrainDonor (12/13/2012)
The best resource is actually here, on SSC: http://www.sqlservercentral.com/articles/trace+flags/70131/. Otherwise you end up hunting in several areas to gather a comprehensive list.
Post #1396068
Posted Thursday, December 13, 2012 2:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, December 4, 2015 3:51 PM
Points: 32, Visits: 335
Got it! Thanks!

GilaMonster (12/13/2012)
There's no official list because many traceflags are undocumented or confidential. Microsoft is not going to go and document a list of undocumented traceflags
Post #1396070
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse