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.

Note

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).