Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a .trc file from a trace that a DBA did on one of my databases. I don't have the SQL profiler tool installed on my PC so I can't view the contents and analyze the trace log. How do I read this file without SQL profiler installed on my PC?

share|improve this question

closed as off-topic by Paul White, RLF, Phil, dezso, bluefeet Jan 26 '15 at 14:26

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, RLF, Phil, dezso, bluefeet
If this question can be reworded to fit the rules in the help center, please edit the question.

Qure Profiler is great... It shows barchars and it's easy to see which queries your server is spending the most time processing. Just make sure you get a really big sample size (it's perfectly happy processing a 2GB trace file). – NickG Feb 3 at 13:31
up vote 5 down vote accepted

Use Clear Trace.

Kevin Kline gives a good summary of ClearTrace : Graphical summary tool gives you clear look into trace/Profiler data

Also if you want a basic profiler, look at ExpressProfiler on codeplex.

ExpressProfiler (aka SqlExpress Profiler) is a simple but good enough replacement for SQL Server Profiler with basic GUI No requirements, no installation. Can be used with both Express and non-Express editions of SQL Server 2005/2008/2008r2/2012 (including LocalDB)


Tracing of basic set of events (Batch/RPC/SP:Stmt Starting/Completed, Audit login/logout - needed events can be selected) and columns (Event Class, Text Data,Login, CPU, Reads, Writes, Duration, SPID, Start/End time) Filter on Duration Copy all/selected event rows to clipboard in form of XML Find in "Text data" column

share|improve this answer
Another tool that has been a life saver is RML – Adam Haines Jul 24 '13 at 21:00
@AdamHaines Agreed, but it will steer up a whole new topic of SQL Nexus :-) – Kin Jul 24 '13 at 21:04

I would probably import the trace to a table, for example:

SELECT * INTO MyTraceTable FROM ::fn_trace_gettable('C:\Path\To\My\Trace\MyTrace.trc',    

If you don't have permissions to create a table, consider using a temporary table or installing SQL Server Express locally and importing the trace there.

Kin's answer (entered concurrently with mine) might be a better option, but I haven't tried ClearTrace yet.

share|improve this answer
Comparing normal profiler and clear trace functionality, in clear trace, you can tell how much CPU, disk reads and writes are done and it shows aggregates as well. I have used it and its a time saver when identifying bottlenecks. This is an online version – Kin Jul 24 '13 at 19:51

Not the answer you're looking for? Browse other questions tagged or ask your own question.