Post reply

sql server traceflags

  • December 13, 2012 at 12:41 am

    #286375

    Hi, does anyone know where on Microsoft site could we find a completed list of traceflags for SQL Server 2008 R2?

    Thanks,

    V

  • December 13, 2012 at 1:35 am

    #1568194

    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

  • December 13, 2012 at 2:36 am

    #1568205

    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

  • December 13, 2012 at 2:44 am

    #1568209

    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.

  • December 13, 2012 at 2:45 am

    #1568211

    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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply