Monday, March 19, 2012

Decoding SQL Profiler .trc files into text?

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?
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@.microsoft.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?

No comments:

Post a Comment