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 need to check for deadlocks in my customer's system. He provided me with unfiltered logs.

Can I filter them after running the trace somehow? (I don't have direct access to his server)

It seems like the template can be applied only before running the trace.

share|improve this question
What format is the trace provided in? A *.trc file? – Martin Smith Jul 30 '13 at 8:28
yes, its .trc format – user2618452 Jul 30 '13 at 9:35
up vote 2 down vote accepted

I don't believe you can apply a template after a trace file is saved, however you can work around this by exporting the results to a table.

If you open the trace file in SQL Profiler and the navigate to File > Save As > Trace Table, you can output the result set to a table in an existing or new database and then you can query/filter the result set to your hearts content.

share|improve this answer
Or use sys.fn_trace_gettable to avoid having to load it all into Profiler first. – Martin Smith Jul 30 '13 at 12:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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