Setup Distributed Replay

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

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.

For SQL2008R2 and below you should Install RML Utilities instead of Distributed Replay.

FineBuild Distributed Replay Utility Setup

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

• FineBuild DRU Controller Setup
• FineBuild DRU Client Setup

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 Setup

Automated DRU Client Setup relates to Process Id 2AR 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

Top

---

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
• Manual DRU Client 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

   Parameter	Function	Description
   /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

   Parameter	Function	Description
   /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.

/VolDBA:\SQLFiles\DRU\Work
/VolDBA:\SQLFiles\DRU\Result

FineBuild will set the default value for the /VolDBA: parameter to the /VolProg: value, but /VolDBA: 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 - 2021. License and Acknowledgements

Previous Install .Net 4.x	Top	Setup RSAT Next