Configure Distributed Replay

The Microsoft SQL Server Distributed Replay configuration details are specified in XML files on the Distributed Replay controller, clients, and where the administration tool is installed. These files include the following:

• Controller configuration file

• Client configuration file

• Preprocess configuration file

• Replay configuration file

Controller Configuration File: DReplayController.config

When the SQL Server Distributed Replay controller service starts, it loads the logging level from the controller configuration file, DReplayController.config. This file is located in the folder where you installed the Distributed Replay controller service:

<controller installation path>\DReplayController.config

The logging level specified by the controller configuration file includes the following:

Setting	XML Element	Description	Allowed Values	Required
Logging level	<LoggingLevel>	Specifies the logging level for the controller service.	INFORMATION | WARNING | CRITICAL	No. By default, the value is CRITICAL.

Example

This example shows a controller configuration file that has been modified to suppress INFORMATION and WARNING log entries.

<?xml version='1.0'?>
<Options>
<LoggingLevel>CRITICAL</LoggingLevel>
</Options>

Client Configuration File: DReplayClient.config

When the SQL Server Distributed Replay client service starts, it loads configuration settings from the client configuration file, DReplayClient.config. This file is located on each client, in the folder where you installed the Distributed Replay client service:

<client installation path>\DReplayClient.config

The settings specified by the client configuration file include the following:

Setting	XML Element	Description	Allowed Values	Required
Controller	<Controller>	Specifies the computer name of the controller. The client will attempt to register with the Distributed Replay environment by contacting the controller.	You can use "localhost" or "." to refer to the local computer.	No. By default, the client tries to register with the controller instance that is running locally ("."), if it exists.
Client working directory	<WorkingDirectory>	Is the local path on the client where the dispatch files are saved. The files in this directory are overwritten on the next replay.	A full directory name, starting with the drive letter.	No. If no value is specified, the dispatch files will be saved in the same location as the default client configuration file. If a value is specified and that folder does not exist on the client, the client service will not start.
Client result directory	<ResultDirectory>	Is the local path on the client where the result trace file from the replay activity (for the client) is saved. The files in this directory are overwritten on the next replay.	A full directory name, starting with the drive letter.	No. If no value is specified, the result trace file will be saved in the same location as the default client configuration file. If a value is specified and that folder does not exist on the client, the client service will not start.
Logging level	<LoggingLevel>	Is the logging level for the client service.	INFORMATION | WARNING | CRITICAL	No. By default, the value is CRITICAL.

Example

This example shows a client configuration file that has been modified to specify that the controller service is running on a different computer, a computer named Controller1. The WorkingDirectory and ResultDirectory elements have been configured to use folders c:\ClientWorkingDir and c:\ResultTraceDir, respectively. The logging level has been changed from the default value to suppress INFORMATION and WARNING log entries.

<?xml version='1.0'?>
<Options>
    <Controller>Controller1</Controller>
    <WorkingDirectory>c:\ClientWorkingDir</WorkingDirectory>
    <ResultDirectory>c:\ResultTraceDir</ResultDirectory>
    <LoggingLevel>CRITICAL</LoggingLevel>
</Options>

Preprocess Configuration File: DReplay.exe.preprocess.config

When you use the administration tool to initiate the preprocess stage, the administration tool loads the preprocess settings from the preprocess configuration file, DReplay.exe.preprocess.config.

Use the default configuration file or use the administration tool -c parameter to specify the location of a modified preprocess configuration file. For more information about using the preprocess option of the administration tool, see Preprocess Option (Distributed Replay Administration Tool).

The default preprocess configuration file is located in the folder where you installed the administration tool:

<administration tool installation path>\DReplayAdmin\DReplay.exe.preprocess.config

The preprocess configuration settings are specified in XML elements that are children of the <PreprocessModifiers> element in the preprocess configuration file. These settings include the following:

Setting	XML Element	Description	Allowed Values	Required
Include system session activities	<IncSystemSession>	Indicates whether system session activities during the capture will be included during replay.	Yes | No	No. By default, the value is No.
Maximum idle time	<MaxIdleTime>	Caps the idle time to an absolute number (in seconds).	An integer that is >= -1. -1 indicates no change from the original value in the original trace file. 0 indicates that there is some activity going on at any given point in time.	No. By default, the value is -1.

Example

The default preprocess configuration file:

<?xml version='1.0'?>
<Options>
    <PreprocessModifiers>
        <IncSystemSession>No</IncSystemSession>
        <MaxIdleTime>-1</MaxIdleTime>
    </PreprocessModifiers>
</Options>

Replay Configuration File: DReplay.exe.replay.config

When you use the administration tool to initiate the event replay stage, the administration tool loads the replay settings from the replay configuration file, DReplay.exe.replay.config.

Use the default configuration file or use the administration tool -c parameter to specify the location of a modified replay configuration file. For more information about using the replay option of the administration tool, see Replay Option (Distributed Replay Administration Tool).

The default replay configuration file is located in the folder where you installed the administration tool:

<administration tool installation path>\DReplayAdmin\DReplay.exe.replay.config

The replay configuration settings are specified in XML elements that are children of the <ReplayOptions> and <OutputOptions> elements of the replay configuration file.

<ReplayOptions> Element

The settings specified by the replay configuration file in the <ReplayOptions> element include the following:

Setting	XML Element	Description	Allowed Values	Required
Target instance of SQL Server (the test server)	<Server>	Specifies the name of the server and instance of SQL Server to connect to.	server_name[\instance_name] You cannot use "localhost" or "." to represent the local host.	No, if the server name is already specified by using the -s target server parameter with the replay option of the administration tool.
Sequencing mode	<SequencingMode>	Specifies the mode that is used for event scheduling.	synchronization | stress	No. By default, the value is stress.
Stress scale granularity	<StressScaleGranularity>	Specifies whether all connections on the Service Profile Identifier (SPID) should be scaled together (SPID) or independently (Connection) under stress mode.	SPID | Connection	Yes. By default, the value is SPID.
Connect time scale	<ConnectTimeScale>	Is used to scale the connect time in stress mode.	An integer between 1 and 100.	No. By default, the value is 100.
Think time scale	<ThinkTimeScale>	Is used to scale think time in stress mode.	An integer between 0 and 100.	No. By default, the value is 100.
Use connection pooling	<UseConnectionPooling>	Specifies whether connection pooling will be enabled on each Distributed Replay client.	Yes | No	Yes. By default, the value is Yes.
Health monitor interval	<HealthmonInterval>	Indicates how often to run the health monitor (in seconds). This value is only used in synchronization mode.	Integer >= 1 (-1 to disable)	No. By default, the value is 60.
Query time-out	<QueryTimeout>	Specifies the query time-out value, in seconds. This value is only effective until the first row has been returned.	Integer >= 1 (-1 to disable)	No. By default, the value is 3600.
Threads per client	<ThreadsPerClient>	Specifies the number of replay threads to use for each replay client.	An integer between 1 and 512.	No. If not specified, Distributed Replay will use a value of 255.

<OutputOptions> Element

The settings specified by the replay configuration file in the <OutputOptions> element include the following:

Setting	XML Element	Description	Allowed Values	Required
Record row count	<RecordRowCount>	Indicates whether the row count should be recorded for each result set.	Yes | No	No. By default, the value is Yes.
Record result set	<RecordResultSet>	Indicates whether the content of all result sets should be recorded.	Yes | No	No. By default, the value is No.

Example

The default replay configuration file:

<?xml version='1.0'?>
<Options>
    <ReplayOptions>
        <Server></Server>
        <SequencingMode>stress</SequencingMode>
        <ConnectTimeScale></ConnectTimeScale>
        <ThinkTimeScale></ThinkTimeScale>
        <HealthmonInterval>60</HealthmonInterval>
        <QueryTimeout>3600</QueryTimeout>
        <ThreadsPerClient></ThreadsPerClient>
    </ReplayOptions>
    <OutputOptions>
        <ResultTrace>
            <RecordRowCount>Yes</RecordRowCount>
            <RecordResultSet>No</RecordResultSet>
        </ResultTrace>
    </OutputOptions>
</Options>

See Also

Reference

Administration Tool Command-line Options (Distributed Replay Utility)

Concepts

SQL Server Distributed Replay

Other Resources

SQL Server Distributed Replay Forum

Using Distributed Replay to Load Test Your SQL Server – Part 2

Using Distributed Replay to Load Test Your SQL Server - Part 1