Post reply

Trace 3604

  • August 14, 2012 at 6:08 am

    #280257

    Good Day,

    I saw in the errorlog of SQL Server 2008r2 the traceflag 3604 is enabled and disabled regularly . I did not configure this trace . I tried to disbale this trace, but without success . What does this trace do and how can one disable it permamently as the hig volume of entries cause confusion.

    Thanks

  • August 14, 2012 at 6:15 am

    #1525450

    It just redirects output from some commands to the client. It's probably a monitoring app that's enabling and disabling it.

    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

  • August 14, 2012 at 6:16 am

    #1525452

    Traceflag 3604 sends the outputs of certain DBCC commands to the SSMS window.

    E.g. If you run DBCC PAGE without first enabling traceflag 3604 you dont see the results, so it is needed to show the results to the client.

    As far as I know you cannot stop it from logging to the error log when it is switched on or off, and also it cannot be disabled.

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

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