|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Wednesday, July 01, 2009 2:09 AM
Points: 11,
Visits: 184
|
|
Hi,
I've set up a server side trace with rollover.
Now I'd like to reload these trace files in another database as a table.
I use the following command:
select *
into TracedData
from ::fn_trace_gettable( @curr_tracefilename, DEFAULT ) Tr
This statement has 2 problems:
1 - It has to load all the data into tempdb before creating the table
since I plan to load huge amount of data this is a problem.
2 - I can't load the files as they have "rolled over"
This function always starts reading at the first trace file 
This forces me to recreate a the trace on a regular base.
Is there a way to tell fn_trace_gettable to load only the last chunk of the rolled-over trace file ?
Thanks
Alren
|
|
|
|
