Database Experimentation Assistant (DEA) is a new Experimentation solution for SQL Server upgrades. It will assist in evaluating a targeted version of SQL for a given workload. Customers who are upgrading from previous SQL server versions (starting 2005 and above) to any new version of the SQL server will be able to use these analysis metrics provided by tool, such as, queries that have compatibility errors, degraded queries and query plans, and other workload comparison data to help them build higher confidence, making it a successful upgrade experience.
The tool offers the following capabilities for workload comparison analysis and reporting:
- Automated script to set up workload capture and replay of production database (using existing SQL server functionality Distributed Replay & SQL tracing)
- Perform statistical analysis model on traces collected using both old and new instances
- Visualize data through analysis report via rich user experience
Target: SQL Server 2012, SQL Server 2014, and SQL Server 2016
You can install from Microsoft Download Center. Run ‘DatabaseExperimentationAssistant.msi’ to install Database Experimentation Assistant tool.