MS SQL Server Tools - Decoding SQL Profiler .trc files into text?

Author

Decoding SQL Profiler .trc files into text?

Snake

2005-03-30, 7:04 pm

Is there a method available to turn a Profiler .trc file into its text
equivalent? We would like to run some parsing tools against Profiler files
but they need to be in some form of delimited text. Doesn't it?

Jasper Smith

2005-03-30, 7:04 pm

I think you would have to use fn_trace_gettable first to load it into SQL
and then export the table to a text file. In SQL2005 you can use SMO to read
a trace from code (e.g. C#,VB.NET) and do what you want with it. You can
also read running traces using both SMO and fn_trace_gettable (in SQL2000
the trace has to be stopped in order to acces it).

--
HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"Snake" <Snake@discussions.microsoft.com> wrote in message
news:035B663B-AA0A-4CAE-A1EA- 92D2114DC1FB@microso
ft.com...
> Is there a method available to turn a Profiler .trc file into its text
> equivalent? We would like to run some parsing tools against Profiler
> files
> but they need to be in some form of delimited text. Doesn't it?

Sponsored Links