Saving Trace Results
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

Saving Trace Results

You can save trace results to a file. A trace file is a file where the trace results are written. A trace file can be located either in a local directory (such as C:\foldername\filename.trc) or a network directory (such as \\computername\sharename\filename.trc).

You can use the trace files to do the following:

  • Replay traces
  • Audit SQL Server
  • Conduct performance analysis
  • Correlate trace events with performance counters to enhance problem detection
  • Perform Database Engine Tuning Advisor analysis
  • Carry out query optimization

SQL Server saves trace results to a file when a path and file name are specified for the @tracefile argument of the stored procedure sp_trace_create.

If a path is specified to the sp_trace_create stored procedure for saving the trace file, the directory must be accessible to the server. Also be aware that if a local directory is specified to sp_trace_create, it is a local directory on the server computer.

If SQL Server Profiler is used, it allows you to save trace results to a file or to a table. Saving trace results to a table allows the same access as saving the trace to a file plus you can query the table to search for specific events.

For more information about saving trace results, see How to: Save Trace Results to a Table (SQL Server Profiler) and How to: Save Trace Results to a File (SQL Server Profiler).

© 2016 Microsoft