Preprocess Option (Distributed Replay Administration Tool)
Applies To: SQL Server 2016
The Microsoft SQL Server Distributed Replay administration tool, DReplay.exe, is a command-line tool that you can use to communicate with the distributed replay controller. This topic describes the preprocess command-line option and corresponding syntax.
The preprocess option initiates the preprocess stage. During this stage, the controller prepares the input trace data for replay against the target server.
For more information about the syntax conventions that are used with the administration tool syntax, see Transact-SQL Syntax Conventions (Transact-SQL).
dreplay preprocess [-m controller] -i input_trace_file -d controller_working_dir [-c config_file] [-f status_interval]
Specifies the computer name of the controller. You can use "
localhost" or "
." to refer to the local computer.
If the -m parameter is not specified, the local computer is used.
Specifies the full path of the input trace file on the controller, such as
D:\Mytrace.trc. The -i parameter is required.
If there are rollover files in the same directory, they will be loaded and used automatically. The files must follow the file rollover naming convention, for example:
Specifies the directory on the controller where the intermediate file will be stored. The -d parameter is required.
The following requirements apply:
The directory must reside on the controller.
You must specify the full path, starting with a drive letter (for example,
The path must not end with a backslash "
UNC paths are not supported.
Is the full path of the preprocess configuration file; used to specify the location of the preprocess configuration file when stored in a different location. This parameter can be a UNC path, or can reside locally on the computer where you run the administration tool.
The -c parameter is not required if no filtering is needed, or if you do not want to modify the maximum idle time.
Without the -c parameter, the default preprocess configuration file,
DReplay.exe.preprocess.config, is used.
Specifies the frequency (in seconds) at which to display status messages.
If -f is not specified, the default interval is 30 seconds.
In this example, the preprocess stage is initiated with all of the default settings. The value
localhost indicates that the controller service is running on the same computer as the administration tool. The input_trace_file parameter specifies the location of the input trace data,
c:\mytrace.trc. Because there is no trace file filtering involved, the -c parameter does have to be specified.
dreplay preprocess –m localhost -i c:\mytrace.trc -d c:\WorkingDir
In this example, the preprocess stage is initiated and a modified preprocess configuration file is specified. Unlike the previous example, the -c parameter is used to point to the modified configuration file, if you have stored it in a different location. For example:
dreplay preprocess –m localhost -i c:\mytrace.trc -d c:\WorkingDir -c c:\DReplay.exe.preprocess.config
In the modified preprocess configuration file, a filter condition is added that filters out system sessions during distributed replay. The filter is added by modifying the
<PreprocessModifiers> element in the preprocess configuration file,
The following shows an example of the modified configuration file:
<?xml version='1.0'?> <Options> <PreprocessModifiers> <IncSystemSession>No</IncSystemSession> <MaxIdleTime>-1</MaxIdleTime> </PreprocessModifiers> </Options>
You must run the administration tool as an interactive user, as either a local user or a domain user account. To use a local user account, the administration tool and controller must be running on the same computer.
For more information, see Distributed Replay Security.