Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server 2016 (13.x),
SQL Server 2017 (14.x), and
SQL Server 2019 (15.x)
Important
SQL Server Distributed Replay is not available with SQL Server 2022 (16.x).
After you install Distributed Replay, you must modify the Distributed Replay controller and client services accounts.
Create firewall rules: On the controller and client computers, you must allow inbound traffic through the firewall for the corresponding service. Specify the firewall rules for the service executables, located in the installation folders.
For the controller service, create a rule for DReplayController.exe, located in the installation folder. For example, the following command enables this rule, where %InstallPath%
is the installation folder of the service:
netsh advfirewall firewall add rule name="allow dreplay controller" dir=in program="%InstallPath%\DReplayController\DReplayController.exe" action=allow
For the client service, on each client computer, create a rule for DReplayClient.exe, located in the installation folder. For example, the following command enables this rule, where %InstallPath%
is the installation folder of the service:
netsh advfirewall firewall add rule name="allow dreplay client" dir=in program="%InstallPath%\DReplayClient\DReplayClient.exe" action=allow
Grant each client permissions on the target server: After you have completed installing the client service on the client computers, you must manually add the client service accounts to the sysadmin role on the target instance of SQL Server.
You must have administrative permissions in order to install any of the Distributed Replay features. Only a SQL Server log in 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.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Perform post-installation configuration of Windows Server - Training
Perform post-installation configuration of Windows Server
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Documentation
Configure distributed replay - SQL Server Distributed Replay
This article describes product requirements to consider before you use the Distributed Replay feature of SQL Server.
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.
Modify controller and client services accounts - SQL Server Distributed Replay
Learn how to modify the Distributed Replay controller and client service accounts, and then reapply the access control lists.