First published on MSDN on Aug 06, 2018
Authored by email@example.com
The Database Experimentation Assistant (DEA) is a new A/B testing solution for SQL Server upgrades. The utility will assist in evaluating a targeted version of SQL for a given workload. Customers who are upgrading from previous SQL Server versions (SQL Server 2005 and above) to any newer version of the SQL Server will be able to use the analysis metrics provided, such as queries that have compatibility errors, degraded queries, query plans, and other workload comparison data, to help them build confidence and better ensure a successful upgrade experience.
The v2.6 release of DEA has the following improvements:
The following postings provide step-by-step guidance for leveraging DEA to perform a workload comparison:
You can download and install DEA from the Microsoft Download Center . Run ‘DatabaseExperimentationAssistant.exe’ to install the Database Experimentation Assistant.
Source: SQL Server 2005 and above
Target: SQL Server 2005 and above
Analysis: SQL Server 2008 and above
Customers can submit feedback by using a simple interface within the DEA tool or by sending an email to firstname.lastname@example.org.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.