Microsoft® SQL Server 2012 Unleashed

Saving and Exporting Traces

In many cases, you want to save or export the trace output generated by a Profiler trace. The output can be analyzed, replayed, imported, or manipulated at a later time after it has been saved. Trace output can be saved as the trace is running or saved after it has been generated to the Profiler GUI. The Trace Properties window provides options for saving trace output while the trace is running. The options are defined using the Save to File and Save to Table options on the General tab of the Trace Properties window. You can save to a file, a table, or both a table and a file. Figure 6.10 shows an example of a trace that will save to both a file and table while it is executing.

FIGURE 6.10 Saving trace output while ...