Perf Mon creating large temp files

I am using a remote connection to connect to a specific server (13B) and I a
m
running a trace from there against another server (138). I have a template t
o
track performance points and am saving the results to a table. My problem is
that when I run this trace, I also am creating a very large set of tmp files
on the local C drive of 13B. The files are named nst1.tmp,prf3.tmp,prf4.tmp.
The C drive space is not very large so I max out the space quickly. I am
looking for a way to point the tmp files to another drive or elimate them
altogether.

Thanks

Never go directly to a table. Place the files on a local hard drive first
and then import them later.  Otherwise you will incur more overhead than you
need to.  If you want to import Perfmon files take a look at the Logman.exe
utility.

--
Andrew J. Kelly  SQL MVP


"MNDiver" <MNDiver@discussions.microsoft.com> wrote in message
news:1F3F9BF1-5D66-4882-83A2- 19C28F1522B1@microso
ft.com...
>I am using a remote connection to connect to a specific server (13B) and I
>am
> running a trace from there against another server (138). I have a template
> to
> track performance points and am saving the results to a table. My problem
> is
> that when I run this trace, I also am creating a very large set of tmp
> files
> on the local C drive of 13B. The files are named
> nst1.tmp,prf3.tmp,prf4.tmp.
> The C drive space is not very large so I max out the space quickly. I am
> looking for a way to point the tmp files to another drive or elimate them
> altogether.
>
> Thanks