Post reply

Agent trace file process

  • May 9, 2016 at 2:14 am

    #307365

    Dear All,

    There is an Agent trace file process which creates files which looks like every other day but the issue is that I do not know where the process is running from. I have checked if it is an SQL Server agent job which is creating the trace file but it is not the case, also as it is not on a set time or date it is not a scheduled process. I would like to know if there is any way of finding out where the process is coming from and how it stop it please?

    Thank you on advance!

  • May 9, 2016 at 2:43 am

    #1877401

    Might be useful if you mention the file name, extension, or at least the pattern of the file names.

    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

  • May 9, 2016 at 2:50 am

    #1877403

    Thank you for your reply! The file extension is .trc

  • May 9, 2016 at 2:58 am

    #1877406

    And the name? Or the pattern of the names?

    On the basis of the extension, that's a profiler trace file, and that's about all that can be concluded.

    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

  • May 9, 2016 at 4:21 am

    #1877416

    The way they are named is as follows:

    221519344_1_1_11_0_20160505181235543_1616

    221519344_1_1_11_0_20160505181235543_1617

    221519344_1_1_11_0_20160505181235543_1615

    But they seem to have a timeline of 1 - 4 minutes apart as the new files are created.

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

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