Post reply

SQL 2012 - Trace flag 3604 turning on and off, sp_server_diagnostic

  • September 10, 2012 at 2:03 pm

    #267583

    Hi -

    Couple of questions..

    1.

    We're running sql 2012 in production.

    During the day, we're experiencing the following throughout the day:

    DBCC TRACEON spid

    DBCC TRACEOFF spid

    No one on our side is running any SQL traces... Purely system generating.

    Anyone experience this type of issue.

    2.

    Seeing the following running all day/night.

    sp_server_diagnostics

    Pssdiag is not running - not sure what/where/how the process was initiated.

    Anyone have any idea's?

  • September 10, 2012 at 2:06 pm

    #1535913

    As for the first, 3rd party monitoring tool running?

    As for the second, clustered instance?

    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

  • September 10, 2012 at 2:22 pm

    #1535917

    1. No - no third party applications even installed on the server. All extended events are disabled.

    2. Always On Availablility Group configured.

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

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