trc to xls

• pnpsql

  SSC-Addicted

  Points: 456

  More actions

  January 8, 2012 at 11:15 pm

  #254699

  i have a .trc trace file and i need to convert it in excel format, is there any tool

• ravikanth.

  Hall of Fame

  Points: 3472

  More actions

  January 9, 2012 at 8:47 am

  #1430532

  no tool to convert to excel...we can convert .trc file into SQL Table..and may be you can copy the table to excel..

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 9, 2012 at 8:54 am

  #1430544

  Query the trace from SQL (fn_trace_gettable) then export as a .csv

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• ravikanth.

  Hall of Fame

  Points: 3472

  More actions

  January 9, 2012 at 11:49 am

  #1430716

  SELECT * FROM fn_trace_gettable('tracefilelocation.trc', default) Trace

• rockfordphile

  Old Hand

  Points: 310

  More actions

  September 26, 2012 at 2:44 pm

  #1542619

  Late to the party, but I did come across a free utility during my own search for such a thing:

  http://sqlmgmt.com/sql/Trace-Converter

  Cmd line, and single file at a time (or table), but it works reasonably well. Wish it'd take a directory!