This project has moved and is read-only. For the latest updates, please go here.

Previous Install .Net 4.x Manual Install Setup RSAT Next

Setup Distributed Replay

FineBuild can setup Distributed Replay Utility (DRU) so that it is ready for use.

Distributed Replay is written by Microsoft and is only available with SQL 2012 and above. It is included in FineBuild because it provides the ability to capture and replay SQL Statements useful for problem resolution or regression testing. It replaces the RML Utilities functionality of older versions of SQL Server.

FineBuild Distributed Replay Utility Setup

There are two DRU processes that can be setup by FineBuild:

FineBuild DRU Controller Setup

To setup the Distributed Replay Controller, the following parameters must be included when you run FineBuild:

Parameter Value Description
SetupDRUCtlr Yes or No Include DRU Controller when SQL Server installed. Default value is No
CtlrSVCAccount DRU Controller Service Account Must be in Domain\Account format. Default value is the SQL Server Service Account
CtlrSvcPassword DRU Controller Service Password Password for service account. Default value is the SQL Server Service Password
CtlrSvcStartupMode Manual or Automatic Startup mode for DRU Controller Service. Default is Manual


The FineBuild DRU Controller setup includes the following items:

Setup Filewall Exception for DRU Controller

FineBuild DRU Client configuration

Automated DRU Client Configuration relates to Process Id 2AQ and is controlled by the parameters below:

Parameter Value Description
SetupDRUClt Yes or No Include DRU Client when SQL Server installed. Default value is Yes.
CltSVCAccount DRU Client Service Account Must be in Domain\Account format. Default value is the SQL Server Service Account
CltSvcPassword DRU Client Service Password Password for service account. Default value is the SQL Server Service Password
CltSvcStartupMode Manual or Automatic Startup mode for DRU Client Service. Default is Manual


The FineBuild DRU Client setup includes the following items:

Setup Folders for DRU Client
Setup DCOM Rights for DRU Client
Setup Filewall Exception for DRU Client
Setup SQL Rights for DRU Client

Manual Distributed Replay Utility Setup

The following steps show what you would have to do for manual DRU setup. FineBuild does all of this work for you automatically.

There are two DRU processes that need to be setup:

Manual DRU Controller Setup

To setup the DRU Controller, the following options must be selected during the SQL Server install process:

1) Include DRU Controller with SQL Server install

Ensure the DREPLAY_CTLR option is selected.

2) Provide the remaining DRU Controller parameters

CtlrSVCAccount DRU Controller Service Account Must be in Domain\Account format. Default value is the SQL Server Service Account
CtlrSvcPassword DRU Controller Service Password Password for service account. Default value is the SQL Server Service Password
CtlrSvcStartupMode Manual or Automatic Startup mode for DRU Controller Service. Default is Manual


Setup Filewall Exception for DRU Controller

Run the following command to setup the Firewall Exception for the DRU Controller

NETSH ADVFIREWALL FIREWALL ADD RULE NAME="SQL DRU Controller" PROGRAM="C:\Program Files (x86)\Microsoft SQL Server\110\Tools\DReplayController\DReplayController.exe" ACTION=ALLOW PROFILE=DOMAIN DIR=IN ENABLE=YES


Top


Manual DRU Client Setup

To setup the DRU Client, the following options must be selected during the SQL Server install process:

1) Include DRU Client with SQL Server install

Ensure the DREPLAY_CLT option is selected.

2) Provide the remaining DRU Client parameters

CltSVCAccount DRU Client Service Account Must be in Domain\Account format. Default value is the SQL Server Service Account
CltSvcPassword DRU Client Service Password Password for service account. Default value is the SQL Server Service Password
CltSvcStartupMode Manual or Automatic Startup mode for DRU Client Service. Default is Manual


Setup Folders for DRU Client

The following folders will be created for the DRU Client.

DrvDBA:\SQLFiles\DRU\Work
DrvDBA:\SQLFiles\DRU\Result

FineBuild will set the default value for the /DrvDBA: parameter to the /DrvProg: value, but /DrvDBA: can be specified if you want to use a different drive.

Setup DCOM Rights for DRU Client

Run the following command on the server hosting the DRU Controller to allow the DRU client to use COM facilities

NET LOCALGROUP "Distributed COM Users" "CltSVCAccount" /ADD


Setup Filewall Exception for DRU Client

Run the following command to setup the Firewall Exception for the DRU Controller

NETSH ADVFIREWALL FIREWALL ADD RULE NAME="SQL DRU Client" PROGRAM="C:\Program Files (x86)\Microsoft SQL Server\110\Tools\DReplayClient\DReplayClient.exe" ACTION=ALLOW PROFILE=DOMAIN DIR=IN ENABLE=YES


Setup SQL Rights for DRU Client

After SQL Server is installed, run the following commands to give the DRU Client the rights needed in SQL Server. The DRU Client needs Sysadmin rights so that it can process a replay file.

CREATE LOGIN [CltSVCAccount] FROM WINDOWS
EXEC {"sp_addsrvrolemember"} 'CltSVCAccount', 'sysadmin'

Copyright FineBuild Team © 2012 - 2016. License and Acknowledgements

Previous Install .Net 4.x Top Setup RSAT Next

Last edited Oct 29, 2016 at 11:24 AM by EdVassie, version 12