SQL Server Profiler - Replay Configuration (Advanced Replay Options)

Applies To: SQL Server 2016

In the Replay Configuration dialog box, use the Advanced Replay Options tab to specify how to replay a trace file.

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, connect to the instance of SQL Server where you want to replay the trace, and then click the Advanced Replay Options tab.

Options

Replay system SPIDs
Specifies whether SQL Server Profiler replays system process identifiers (SPIDs).

Replay one SPID only
Replays only the activity in the source trace file that is related to the selected SPID.

SPID to replay
Specify which SPID to replay.

Limit replay by date and time
Check to replay only a portion of the source trace file.

Start time
Date and time in the source trace file where the replay should start.

End time
Date and time in the source trace file where the replay should stop.

Health monitor wait interval (sec)
Specify the wait interval to replay in seconds. Default is 3600 seconds (1 hour). This setting affects the amount of time a process is allowed to run before being terminated by the health monitor.

Health monitor poll interval (sec)
Specify the health monitor poll interval during replay in seconds. Default is 60 seconds. This value allows the user to configure how often the health monitor polls for candidates for termination.

Enable SQL Server blocked processes monitor
Enables a process that searches for blocked or blocking processes.

Blocked processes monitor wait interval (sec)
Configures how often the blocked processes monitor searches for blocked or blocking processes.

See Also

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