Re: SQL2k Profiler: load big trace file into table, on small system ?

Tech-Archive recommends: Fix windows errors by optimizing your registry

I am in a SQL2k environment, and am working on a machine with maybe 500 MB
of
free space on its C:\ drive, where the SQL2k binaries are installed.

I have some profiler files I generated on another box, some up to 2.5 GB
in
size.

When trying to open the files, I get the error: "System is low on disk
space
on drive
'C'. All SQL Profiler functions are temporarily disabeled." Apparently
Profiler tries
to load the trace file, and in the process creates another temporary work
file, on C:, into which it tries to load the trace log. Apparently when
there's no more space on C:\, profiler stops, and then loads - just the
incomplete trace data read so far - from profiler into a SQL table I
specify..

I need to load the whole trace log file into the table. How can I do that
in
the
existing environment ? Is there perhaps a reg key I can tweak to get the
temp file
re-directed to a different location, with more space ?

A magical key that allows you to tweak the C drive size as in:

Read 500 Mb as to be 50 Gb so that my 2.5 Gb file will fit?


--
Martijn Tonies


.

Relevant Pages

  • Re: SQL2k Profiler: load big trace file into table, on small syste
    ... Andrew J. Kelly SQL MVP ... I have some profiler files I generated on another box, ... file, on C:, into which it tries to load the trace log. ... I need to load the whole trace log file into the table. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL2k Profiler: load big trace file into table, on small system ?
    ... Why use profiler to load the trace into a table? ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Server 2000 Profiler
    ... So what I am taking from this is that this is an issue and there is not a way around it in profiler?!? ... This way I could load it when I want or need to. ... This is indeed an issue with Profiler filtering IIRC. ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.tools)
  • Re: Measuring Load Balancing
    ... timestep, where load does not change, and then sum over all the ... However, I cannot find a profiler that gives me this, or one ... wasted due to load imbalance. ... calls to MPI_Wtime to figure out my time wasted due to load imbalance ...
    (comp.parallel.mpi)