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).
See Also
Tasks
How to: Create a Trace (Transact-SQL)
How to: Create a Trace (SQL Server Profiler)
Other Resources
sp_trace_create (Transact-SQL)