October 31, 2002 at 9:26 am
How can I get a trace file(.trc) into a table?
October 31, 2002 at 9:38 am
Open the trace file with "Profiler" then use the "Save As..." option to save it to a "Trace Table...".
This should do the trick.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
October 31, 2002 at 9:58 am
that won't work.
This did:
fn_trace_gettable
ex.
USE PERFORMANCEDB
SELECT * INTO globexSTR50b
FROM ::fn_trace_gettable('G:\Perf_Logs\Globex_STR_Oct29\globexSTR50b.trc', default)
October 31, 2002 at 10:10 am
Nice to know about the option that worked. Why didn't the "Save As" work?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
October 31, 2002 at 10:46 am
when I open an existing .trc file,
the SAVE AS options are greyed out.
October 31, 2002 at 11:38 am
Gee, on my machine when I first open profiler the "Save As" is greyed out, then when I open and existing .trc file, the "Save As" becomes available.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
October 31, 2002 at 12:10 pm
you using 2000 profiler?
October 31, 2002 at 12:12 pm
ya you must be using 7.0 profiler. I just got the same result are you.
October 31, 2002 at 12:15 pm
AH,
this is kinda tricky.
In 2000 profiler, you have to wait for all the rows to be put in Profiler(no indicator) before the greyed out save as will be enabled.
October 31, 2002 at 1:07 pm
Guess I had just a small trace file. It worked in both SQL 7 and 2000 for me. I appreciate the answer on why, and how you have to wait. Thank you for the research!
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply