Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

trc to xls Expand / Collapse
Author
Message
Posted Sunday, January 8, 2012 11:15 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 6:23 AM
Points: 15, Visits: 224
i have a .trc trace file and i need to convert it in excel format, is there any tool
Post #1232209
Posted Monday, January 9, 2012 8:47 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 2:53 PM
Points: 1,630, Visits: 1,813
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
Posted Monday, January 9, 2012 8:54 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:06 PM
Points: 43,007, Visits: 36,161
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
Posted Monday, January 9, 2012 11:49 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 2:53 PM
Points: 1,630, Visits: 1,813
SELECT * FROM fn_trace_gettable('tracefilelocation.trc', default) Trace
Post #1232707
Posted Wednesday, September 26, 2012 2:44 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 8, 2014 10:48 AM
Points: 10, Visits: 117
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 »

Add to briefcase

Permissions Expand / Collapse