Export (0) Print
Expand All

SQL Server Profiler - Replay Configuration (Advanced 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 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.

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.

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

Community Additions

© 2015 Microsoft