trc to xls

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » trc to xls

trc to xls

Rate Topic

Display Mode

Topic Options

Author

Message

pnpsql

Posted Sunday, January 08, 2012 11:15 PM

Grasshopper

Group: General Forum Members
Last Login: Sunday, March 31, 2013 12:23 PM
Points: 15, Visits: 186

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

Post #1232209

ravikanth.

Posted Monday, January 09, 2012 8:47 AM

SSCommitted

Group: General Forum Members
Last Login: Monday, April 29, 2013 8:05 AM
Points: 1,602, Visits: 1,768

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

Post #1232497

GilaMonster

Posted Monday, January 09, 2012 8:54 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:18 PM
Points: 37,744, Visits: 30,025

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

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1232510

ravikanth.

Posted Monday, January 09, 2012 11:49 AM

SSCommitted

Group: General Forum Members
Last Login: Monday, April 29, 2013 8:05 AM
Points: 1,602, Visits: 1,768

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

Post #1232707

rockfordphile

Posted Wednesday, September 26, 2012 2:44 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 15, 2013 2:25 PM
Points: 5, Visits: 55

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!

Post #1364936

« Prev Topic | Next Topic »

Permissions