SQL Server Profiler - Replay Configuration (Basic Replay Options)

SQL Server Profiler - Replay Configuration (Basic Replay Options)

 

Applies To: SQL Server 2016

In the Replay Configuration dialog box, use the Basic Replay Options page to specify how to replay a trace file or table.

To view this window, use SQL Server Profiler to open a trace file or table that contains the appropriate events for replay. For more information, see Replay Requirements. While the trace file or table is open, on the Replay menu, click Start, and then connect to the instance of SQL Server where you want to replay the trace.

Replay server
Displays the instance of SQL Server to connect to for the replay.

Change...
Launches the Connect to Server dialog box to connect to another server.

Save to file
Save the replay results to a file. SQL Server Profiler displays the standard file dialog, where you can specify the location to save the file.

Save to table
Save the replay results to a table. SQL Server Profiler displays the table selection dialog, where you can specify the location to save the table.

Number of replay threads
Specify the number of replay threads to use concurrently. A higher number consumes more resources during replay, but replay is faster and more concurrent.

Replay events in the order they were traced
Replay events sequentially. Use this option if you are replaying a trace for debugging.

Replay events using multiple threads
Replay events concurrently. This option is faster than replaying events sequentially, but disables debugging. The events are ordered within their system process identifiers (SPID).

Display replay results
Display replay results in SQL Server Profiler.

Replay a Trace Table (SQL Server Profiler)
Replay a Trace File (SQL Server Profiler)
Replay Traces

Community Additions

ADD
Show:
© 2016 Microsoft