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?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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:
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.
I would probably import the trace to a table, for example:
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.