Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniuNí thacaítear leis an mbrabhsálaí seo a thuilleadh.
Uasghrádú go Microsoft Edge chun leas a bhaint as na gnéithe is déanaí, nuashonruithe slándála, agus tacaíocht theicniúil.
Nóta
This tool will be retired on December 15, 2024. We will stop supporting this tool for any issues that arise, and will not issue any bug fixes or further updates.
Database Experimentation Assistant (DEA) uses the Distributed Replay tools from the SQL Server installation to replay a captured trace against an upgraded test environment. We recommend doing a test run by using a small trace file before doing a full replay to ensure proper replay of queries.
Distributed Replay requires you to use common accounts between machines. Because of this requirement, and for security reasons, we recommend running Distributed Replay on a virtual network or on a domain-controlled network:
To set up the controller service:
Install the Distributed Replay controller by using the SQL Server installer. If you skipped the SQL Server Installer wizard step that configures the Distributed Replay controller, you can configure the controller through the configuration file. In a typical installation, the configuration file is located at C:\Program Files (x86)\Microsoft SQL Server<version>\Tools\DReplayController\DReplayController.config.
Distributed Replay controller logs are located at C:\Program Files (x86)\Microsoft SQL Server<version>\Tools\DReplayController\Log.
Open Services.msc and go to the SQL Server Distributed Replay Controller service.
Right-click on the service, and then select Properties. Set the service account to an account that is common to the controller and client machines in the network.
Select OK to close the Properties window.
Restart the SQL Server Distributed Replay Controller service from Services.msc. You also can run the following commands at the command line to restart the service:
NET STOP "SQL Server Distributed Replay Controller"
NET START "SQL Server Distributed Replay Controller"
For more configuration options, see Configure Distributed Replay.
This configuration is only required on the controller computer.
Open dcomcnfg.exe.
Expand Component Services > Computers > My Computer > DCOM Config.
Under DCOM Config, right-click DReplayController, and then select Properties.
Select the Security tab.
Under Launch and Activation Permissions, select Customize, and then select Edit.
Add the user that will be starting the replay. Give the user Local Launch and Local Activation permissions. If the user plans to launch or activate remotely, give the user Remote Launch and Remote Activation permissions.
Select OK to commit the changes and return to the Security tab.
Under Access Permissions, select Customize, and then select Edit.
Add the user that will be starting the replay. Give the user Local Access permissions. If the user plans to access the controller service remotely, give the user Remote Access permissions.
Select OK to commit the changes and return to the Security tab.
Select OK to commit the changes.
Restart the SQL Server Distributed Replay Controller service from Services.msc. You also can run the following commands at the command line to restart the service:
NET STOP "SQL Server Distributed Replay Controller"
NET START "SQL Server Distributed Replay Controller"
Before you set up the client service, use networking tools like ping to verify that the controller and client computers can communicate.
Install the Distributed Replay client by using the SQL Server installer.
Open Services.msc and go to the SQL Server Distributed Replay Client service.
Right-click on the service, and then select Properties. Set the service account to an account that is common to both the controller and client machines in the network.
Select OK to close the Properties window. If you skipped the SQL Server Installer wizard step to configure the Distributed Replay client, you can configure it through the configuration file. In a typical installation, the configuration file is located at C:\Program Files (x86)\Microsoft SQL Server<version>\Tools\DReplayClient\DReplayClient.config.
Ensure that the DReplayClient.config file contains the name of the controller machine as its controller for registration.
Restart the SQL Server Distributed Replay Client service from Services.msc. You also can run the following commands from the command line to restart the service:
NET STOP "SQL Server Distributed Replay Client"
NET START "SQL Server Distributed Replay Client"
Distributed Replay controller logs are located at C:\Program Files (x86)\Microsoft SQL Server<version>\Tools\DReplayClient\Log. The logs indicate whether the client can register itself with the controller.
If the configuration is successful, the log displays the message Registered with controller <controller name>.
For more configuration options, see Configure Distributed Replay.
You can use Distributed Replay administration tools to quickly test whether Distributed Replay is functioning properly in the environment. Testing the configuration can be especially helpful in an environment in which multiple client machines are registered with a controller. You might need to install SQL Server Management Studio (SSMS) to get the administration tools.
dreplay.exe status -f 1
.If the preceding steps were successful, the console output indicates that the controller can see its clients in a READY
state.
Remotely accessing Distributed Replay requires opening ports that are visible within the domain or virtual network.
Two replays are required to run an A/B test or an experiment. That is, you might need two separate instances of SQL Server installations for a migration scenario.
You can also install the two versions of SQL Server instances on the same machine. A caveat is to make sure that the instances are isolated when a replay is in progress.
The following steps must be performed for each replay:
Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniuOiliúint
Modúl
Migrate SQL Server workloads to Azure SQL Managed Instance - Training
Migrate SQL Server workloads to Azure SQL Managed Instance
Deimhniú
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.