Wouldn’t it be nice if you may see however a work can perform during a new setting before migrating a information to the cloud? After that one can fix all queries that are compatible errors or move to next with the migration confidently.
That style of globe is actually what Microsoft offers United States within the variety of Microsoft information Experimentation Assistant (DEA). To find out regarding the advantages of an alternative Azure information capabilities, scan Future-Proof Your knowledge Infrastructure with Azure: A Business Case for information directors.

The information Experimentation Assistant permits you to judge a targeted version of SQL Server for a selected work. By conducting A/B testing, you’ll be able to see however, the work on the supply server in your current setting can perform within the new setting. The information Experimentation Assistant has the flexibility to capture and replay on Azure SQL information, Azure SQL Managed Instance, and SQL Server on Linux. The information Experimentation Assistant provides analysis metrics to spot potential problems once upgrading from earlier versions of SQL Server beginning with 2005 to more modern versions. Information Experimentation Assistant analysis metrics include:

Queries that are compatible errors.
Degraded queries and question plans.
Other work comparison knowledge.

Prerequisites for running Database Experimentation Assistant

Make sure you meet the subsequent conditions before running information Experimentation Assistant:The minimum hardware demand may be a single-core machine with three.5 GB of RAM.
The ideal hardware demand is Associate in Nursing eight-core central processor (with three.5 GB of RAM or more). Note: information Experimentation Assistant run times do not improve on processors with over eight cores.
An additional thirty-three% of the performance trace size is required to store analysis databases A, B, and reports.
The user running information Experimentation Assistant should be ready to hook up with the information servers victimization Windows authentication.
The user should even have sysadmin rights on each the supply and target information servers.

Running Database Experimentation Assistant

Database Experimentation Assistant guides you through Associate in Nursing A/B take a look at of your supply and projected servers in 3 stages:

1. Capture a work trace
The first stage is to capture a work trace on the supply server, that is sometimes the assembly server. Trace files capture the complete question work on a server, together with timestamps. Before you begin, make a copy the databases.
Note: a question should execute a minimum of fifteen times throughout the capture amount for the information Experimentation Assistant to see whether performance can improve or degrade within the new setting.

2. Replay a work trace
Next, replay the trace file on 2 target servers. Target one can mimic your supply server, and Target 2 can mimic the projected target setting. The hardware configurations of the targets ought to be as similar as doable to change SQL Server to investigate the result your projected changes wear performance. To replay a work trace, your computers should be started to run distributed replay traces.

3. Analyze the replayed work traces
Finally, generate Associate in Nursing analysis report victimization the replay traces, and review the report for insights regarding potential performance implications within the new setting.

Learn more
Migrating SQL Server to the cloud is a significant enterprise. That’s a lot of assurances you’ve got that the migration are going to be successful, the better. As Associate in Nursing experimentation answer for SQL Server upgrades, information Experimentation Assistant will assist you assess a targeted version of SQL Server for a selected work. You’ll be able to then rest assured that the work can perform needless to say and may proceed with confidence together with your migration.

By: SQL SERVER TEAM