Export (0) Print
Expand All

SQL Server Profiler - Replay Configuration (Basic Replay Options)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.


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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft