Post reply

DBCC Traceon

  • December 5, 2011 at 9:54 am

    #247884

    Good Day , I noticed in the SQL Server Errorlog there is a high volume of dbcc traceon and dbcc traceoff statements. I ran the dbcc tracestatus statement to check if any traceflags are enabled. Hoever I could not find any . Are there any other statement(s) needed to disable these entries ?

  • December 5, 2011 at 9:57 am

    #1416824

    What traceflags are being turned on and off?

    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 5, 2011 at 9:59 am

    #1416828

    3605, 3604, 1222

  • December 5, 2011 at 10:03 am

    #1416834

    3604 and 3605 are used to direct certain output (like DBCC Page) to the client or the error log respectively. Some people/apps assume incorrectly that they are needed to get deadlock graphs logged.

    1222 is used to log deadlock graphs to the error log.

    Got some 3rd party monitoring tool? Especially the deadlock one, it's the kind of thing a monitoring tool might be running.

    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

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

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