Re: SQL2k Profiler: load big trace file into table, on small system ?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 17 Oct 2007 22:12:39 +0000 (UTC)
Steve M (SteveM@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
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 ?
Control Panel->System->Advanced->Environment Variables. Change TEMP and TMP.
These two environment variables are used by many programs in Windows.
You could start looking at what directories they point to now. Chances are
that you could find a lot to clean up there.
Of course, Andrews advice of using fn_trace_gettable is the right soluition
in this case. Nevertheless, the knowledge about %TEMP% and %TMP% may be
useful in the future.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: Bcp problem (2005), previously posted to microsoft.public.sqlserver.programming
- Next by Date: SQL Server Client Tools Free to Distribute?
- Previous by thread: Re: SQL2k Profiler: load big trace file into table, on small syste
- Next by thread: Bcp problem (2005), previously posted to microsoft.public.sqlserver.programming
- Index(es):
Relevant Pages
|
