| title | titleSuffix | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | monikerRange |
|---|---|---|---|---|---|---|---|---|---|---|---|
Install Distributed Replay |
SQL Server Distributed Replay |
This article describes the ways you can install Distributed Replay: using the Installation Wizard, the Command Prompt window, or a configuration file. |
markingmyname |
maghan |
mikeray |
06/20/2022 |
sql |
distributed-replay |
conceptual |
intro-installation |
>= sql-server-2016 || >= sql-server-linux-2017 |
[!INCLUDE sqlserver2016-2019-only]
[!INCLUDE distributed-replay-sql-server-2022]
You can install Distributed Replay in one of three ways:
Install the Microsoft[!INCLUDEssNoVersion] Distributed Replay features with the [!INCLUDEssnoversion] Installation Wizard. When planning where to install the features, consider the following:
-
You can install the administration tool on the same computer as the Distributed Replay controller, or on different computers.
-
There can only be one controller in each Distributed Replay environment.
-
You can install the client service on up to 16 (physical or virtual) computers.
-
Only one instance of the client service can be installed on the Distributed Replay controller computer. If your Distributed Replay environment will have more than one client, we don't recommend installing the client service on the same computer as the controller. Doing so may decrease the overall speed of the distributed replay.
-
For performance testing scenarios, we don't recommend installing the administration tool, Distributed Replay controller service, or client service on the target instance of [!INCLUDEssNoVersion]. Installing all of these features on the target server should be limited to functional testing for application compatibility.
-
After installation, the controller service, [!INCLUDEssNoVersion] Distributed Replay controller, must be running before you start the Distributed Replay client service on the clients.
Note
To remove or change the Distributed Replay features, use the Windows Programs and Features window in Control Panel. Select [!INCLUDEssnoversion] in the Uninstall or change a program window, and then select Remove to open the [!INCLUDEssnoversion] Installation Wizard. On the Select Features page, check the Distributed Replay features you want to remove.
Prerequisites:
-
Make sure that the computers that you want to use meet the requirements that are described in the topic Distributed Replay Requirements.
-
Before you begin this procedure, you create the domain user accounts that the controller and client services will run under. We recommend that these accounts aren't members of the Windows Administrators group. For more information, see the User and Service Accounts section in the Distributed Replay Security topic.
[!NOTE]
You can use local user accounts if you are running the administration tool, controller service, and client service on the same computer.
Installation Locations:
Assuming you use the default file locations and a standard installation, the base directory is found at C:\Program Files\Microsoft SQL Server. Within that, following are where the binaries and assemblies are installed to:
-
On a 32-bit system:
[!INCLUDEssInstallPath]Tools
- OR -
<Share Feature Directory>\Tools\(user-supplied alternative shared feature directory)
-
On a 64-bit system:
C:\Program Files\Microsoft[!INCLUDEssNoVersion] (x86)\130\Tools
- OR -
<Share Feature Directory (x86)>\Tools\(user-supplied alternative shared feature (x86) directory)
-
To start the installation of any of the Distributed Replay features, start the [!INCLUDEssnoversion] Installation Wizard.
-
The Setup Support Rules page identifies issues that might occur when installing the SQL Server Setup support files. You must correct any Setup support failures before continuing with Setup.
-
On the Product Key page, select an option button to indicate whether you're installing a free edition of [!INCLUDEssNoVersion], or a production version of the product that has a PID key. For more information, see Editions and supported features of SQL Server 2022.
-
On the License Terms page, read the license agreement, and then select the check box to accept the license terms and conditions. To help improve [!INCLUDEssNoVersion], you can also enable the feature usage option and send reports to Microsoft.
-
On the Setup Support Files page, select Install to install or update the Setup Support files for [!INCLUDEssnoversion].
-
On the Setup Role page, select [!INCLUDEssNoVersion] Feature Installation, and then select Next to continue to the Feature Selection page.
-
On the Feature Selection page, configure which features you want to install.
-
To install the administration tool, select Management Tools - Basic.
-
To install the controller service, select Distributed Replay Controller.
-
To install the client service, select Distributed Replay Client.
[!IMPORTANT]
When you configure Distributed Replay controller, you can specify one or more user accounts that will be used to run the Distributed Replay client services. The following is the list of supported accounts: -
Domain user account
-
User created local user account
-
Administrator
-
Virtual account and MSA (Managed Service Account)
-
Network Services, Local Services, and System
Group accounts (local or domain) and other built-in accounts (like Everyone) aren't accepted.
-
-
Optionally, select the ellipsis (...) button to change the shared feature directory path.
-
On 32-bit computers, the default installation path is C:\Program Files\Microsoft[!INCLUDEssNoVersion]\
-
On 64-bit computers, the default installation path is C:\Program Files (x86)\Microsoft[!INCLUDEssNoVersion]\
-
-
When you're finished, select Next.
-
On the Installation Rules page, [!INCLUDEssNoVersion] Setup validates your computer configuration. Once the validation process is completed, select Next.
-
The Disk Space Requirements page calculates the required disk space for the features that you specify. Then it compares the required space to the available disk space.
-
On the Error Reporting page, specify the information that you want to send to Microsoft to help improve [!INCLUDEssNoVersion]. By default, option for error reporting is enabled.
-
On the Installation Configuration Rules page, the System Configuration Checker will run one more set of rules to validate your computer configuration with the [!INCLUDEssNoVersion] features that you've specified.
-
On the Ready to Install the Program page, select Install.
[!IMPORTANT]
After you install Distributed Replay you must create firewall rules on the controller and client computers, and grant each client computer permissions on the target server. For more information, see Complete the Post-Installation Steps.
You must have administrative permissions in order to install any of the Distributed Replay features. Only a [!INCLUDEssNoVersion] login having sysadmin permissions can add the client service accounts to the sysadmin server role of the test server. For more information about Distributed Replay security considerations, see Distributed Replay Security.
Installing a new instance of Distributed Replay at the command prompt enables you to specify the features to install and how they should be configured. The command prompt installation supports installing, repairing, upgrading, and uninstalling of the Distributed Replay components. When installing through the command prompt, [!INCLUDEssNoVersion] supports full quiet mode by using the /Q parameter.
Note
For local installations, you must run Setup as an administrator. If you install [!INCLUDEssNoVersion] from a remote share, you must use a domain account that has read and execute permissions on the remote share.
The list of top-level features include [!INCLUDEssNoVersion], [!INCLUDEssASnoversion], [!INCLUDEssRSnoversion], [!INCLUDEssISnoversion], and Tools. The Tools feature will install [!INCLUDEssNoVersion] Management Tools, [!INCLUDEssNoVersion] Books Online, [!INCLUDEssBIDevStudioFull], and other shared components. To install the Distributed Replay components, specify the following parameters:
| Component | Parameter |
|---|---|
| Distributed Replay controller | DREPLAY_CTLR |
| Distributed Replay client | DREPLAY_CLT |
| Administration Tool | Tools |
Important
After you install Distributed Replay you must create firewall rules on the controller and client computers, and grant each client computer permissions on the target server. For more information, see Complete the Post-Installation Steps.
Use the parameters in the following table to develop command line scripts for installation.
| Parameter | Description | Supported Values |
|---|---|---|
| /CTLRSVCACCOUNT Optional |
Service account for the Distributed Replay controller service. | Checks account and password |
| /CTLRSVCPASSWORD Optional |
Password for the Distributed Replay controller service account. | Checks account and password |
| /CTLRSTARTUPTYPE Optional |
Start up type for the Distributed Replay controller service. | Automatic Disabled Manual |
| /CTLRUSERS Optional |
Specify which users have permissions for the Distributed Replay controller service. | Set of user account strings using " " (space) for delimiter Important: When you configure the Distributed Replay controller service, you can specify one or more user accounts that will be used to run the Distributed Replay client services. The following is the list of supported accounts: Domain user account User created local user account Administrator Administrator Virtual account and MSA (Managed Service Account) Network Services, Local Services, and System Note: Group accounts (local or domain) and other built-in accounts (like Everyone) aren't accepted. |
| /CLTSVCACCOUNT Optional |
Service account for the Distributed Replay client service. | Checks account and password |
| /CLTSVCPASSWORD Optional |
Password for the Distributed Replay client service account. | Checks account and password |
| /CLTSTARTUPTYPE Optional |
Start up type for the Distributed Replay client service. | Automatic Disabled Manual |
| /CLTCTLRNAME Optional |
The computer name that the client communicates with for the Distributed Replay Controller service. | |
| /CLTWORKINGDIR Optional |
The working directory for the Distributed Replay Client service. | Valid path |
| /CLTRESULTDIR Optional |
The result directory for the Distributed Replay Client service. | Valid path |
To install the Distributed Replay controller component
setup /q /ACTION=Install /FEATURES=DREPLAY_CTLR /IAcceptSQLServerLicenseTerms /CTLRUSERS="domain\user1" "domain\user2" /CTLRSVCACCOUNT="domain\svcuser" /CTLRSVCPASSWORD="password" /CTLRSTARTUPTYPE=Automatic
To install the Distributed Replay client component
setup /q /ACTION=Install /FEATURES=DREPLAY_CLT /IAcceptSQLServerLicenseTerms /CLTSVCACCOUNT="domain\svcuser" /CLTSVCPASSWORD="password" /CLTSTARTUPTYPE=Automatic /CLTCTLRNAME=ControllerMachineName /CLTWORKINGDIR="C:\WorkingDir" /CLTRESULTDIR="C:\ResultDir
[!INCLUDEssNoVersion] Setup provides the ability to generate a configuration file based on user input and system defaults. If you specify that you want the Management tools installed, you can use the configuration file to deploy the three Distributed Replay components (administration tool, Distributed Replay controller, and the Distributed Replay client). It supports Installing, repairing, and uninstalling of the Distributed Replay components.
Setup supports the use of the configuration file only through the command-line. The processing order of the parameters while using the configuration file is outlined below:
-
The configuration file overwrites the defaults in a package
-
Command-line values overwrite the values in the configuration file
For more information about how to use a configuration file, see Install SQL Server 2016 Using a Configuration File.
Important
After you install Distributed Replay you must create firewall rules on the controller and client computers, and grant each client computer permissions on the target server. For more information, see Complete the Post-Installation Steps.
-
Follow the Setup wizard through to the Ready to Install page. The path to the configuration file is specified in the Ready to Install page in the configuration file path section.
-
Cancel the setup without actually completing the installation, to generate the INI file.
- Run the installation through the command prompt and supply the ConfigurationFile.ini using the ConfigurationFile parameter.
Sample Syntax
Following is an example of how to specify the configuration file at the command prompt:
Setup.exe /CTLRSVCPASSWORD="ctlrsvcpswd" /CLTSVCPASSWORD="cltsvcpswd" / ConfigurationFile=ConfigurationFile.INI\
Note
You must specify both passwords in the command line because you cannot configure them in the configuration file.