Preprocess Option (Distributed Replay Administration Tool)
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).
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, DReplay.exe.preprocess.config.
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.