Replay SQL Server

SQL Profiler Help

SQL Profiler Help

Replay SQL Server

Use this dialog box to view or specify the following options.

Options

Replay SQL Server

Specify the server against which to replay the trace. Replay is used to re-create previously captured Microsoft® SQL Server™ activity to debug or profile events, or to stress the server.

Output file name

Specify the name and location of the file where the replay output will be saved. Save the output file to review and analyze errors and results at a later time.

Replay events in the order they were traced. This option enables debugging.

Specify to replay events in the order they were traced. This allows you to use debugging methods such as stepping through each trace.

Replay events using multiple threads. This option optimizes performance and disables debugging.

Specify to replay events using multiple threads. This optimizes performance, but debugging is disabled.

Display replay results

Specify to display the results of the replay. This is the default option. If the trace you are replaying is very large, you may want to disable this to save disk space.

See Also

How to open a trace data file (SQL Profiler)