Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Tuesday, March 18, 2014 11:50 PM
Points: 32, Visits: 292
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: Yesterday @ 7:48 AM
Points: 1,533, Visits: 7,916
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.

BrainDonor
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 @ 7:46 AM
Points: 41,528, Visits: 34,444
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 2008, MVP
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: Tuesday, March 18, 2014 11:50 PM
Points: 32, Visits: 292
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: Tuesday, March 18, 2014 11:50 PM
Points: 32, Visits: 292
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