|
Home > Archive > MS SQL Server > August 2005 > Perf Mon creating large temp files
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Perf Mon creating large temp files
|
|
| MNDiver 2005-08-31, 9:23 am |
| 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
| |
| Andrew J. Kelly 2005-08-31, 11:23 am |
| 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
|
|
|
|
|