.trc trace file format
-
Hello !
I'm relatively new in SQL Server Central and I thank very much all the subscribers for their daily help.
Now my question : I can't find any documentation about the trace file format (You know : when you don't want to trace into a SQL server table). I have found some elements of answer by using an hexadecimal editor, but I lack some fields (start and end time e.g.) to finish the job (automatic trace analysis on a big date range).
All answers greatly appreciated !!!
-
Check BOL for fn_trace_gettable. This doesn't "decode" the trace file, but you can import the data from a trace file to a temp table and query it there. I'm not aware of any utilities that read the .trc file as it sits (other than Profiler, naturally...)
Cheers,
Ken
-
A lot depends on what you want to do. If you just want to work over the data, there are a number of utilities and routines that will convert "native" trace data from the binary to something legible; I'd recommend using SQL Profiler, opening (or creating) the trace, and then working over the File/Save As options. I suspect you're on your own if you need to read the native binary...
Philip
-
You're right, Philip. I wrote an application that can run concurrents sp on our servers and analyze the trc files to point out the potential problems occuring when the charge is high (many users, some deadlocks, network slow-down and so ...). I use the trc files because I don't want to generate any supplemental charge and tables on the different servers.Thanks for your answer !
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply