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.

  • What format is the trace provided in? A *.trc file? Commented Jul 30, 2013 at 8:28
  • yes, its .trc format Commented Jul 30, 2013 at 9:35

1 Answer 1


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.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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