Re: Profiler temp file
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Thu, 3 May 2007 10:53:16 -0400
Well you really shouldn't be using profiler for such things anyway. The more
efficient way to do this is to create a trace and send the trace events
directly to a file on a drive attached to the server. Then you can copy that
file to your local machine and view it in Profiler or dump it into a table
for querying. If you set up a trace definition in Profiler, run it for a
second and then stop it you can go to File - Script trace to generate an
almost ready made script for your trace.
--
Andrew J. Kelly SQL MVP
"Nancy Lytle" <nancy_lytle@xxxxxxxxxxxxxxx> wrote in message
news:O2Gku9YjHHA.1240@xxxxxxxxxxxxxxxxxxxxxxx
Is there any way to move the temp file that is create by Profiler (used
for the datagrid scrolling screen) from the C: drive? Our C drive is not
large enough to allow a long Profiler session, since the Profiler temp
file ends up filling up the C drive.
Nancy
.
- Follow-Ups:
- Re: Profiler temp file
- From: Nancy Lytle
- Re: Profiler temp file
- References:
- Profiler temp file
- From: Nancy Lytle
- Profiler temp file
- Prev by Date: Profiler temp file
- Next by Date: Re: Profiler temp file
- Previous by thread: Profiler temp file
- Next by thread: Re: Profiler temp file
- Index(es):
Relevant Pages
|
