Post reply

Profiler and tmp files

  • June 19, 2008 at 2:15 am

    #192540

    I've started using profiler to do a baseline trace on a production server. I started profiler on a 'client' server and notice the C-disk fill up very rapidly. Some searching shows me a few tmp files growing very rapidly. These files have a name pattern of Prf*.tmp. I understand this is by design. My question: is it possible to have these tmp files use an other partition then C? I have to stop the trace every few hours and start a new to clear these files, which is very annoying.

    Sofar I cannot find any help on this subject.

    Help?

    Greetz,
    Hans Brouwer

  • June 19, 2008 at 2:43 am

    #830952

    When you set up the trace, do you set it to write the trace to disk?

    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

  • June 19, 2008 at 5:35 am

    #831000

    Nope, it writes to a table. However, reading some articles on this I gather that does not matter; Profiler just uses this as some sort of buffer. Just being able to have this done on another partition then C would help me fine, but dunno how to accomplish that, if it IS possible...

    Greetz,
    Hans Brouwer

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

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