In the Channel 9 studios this week is Harini Gupta, a Senior Program Manager on the SQL Server SEALS team, and Dinek Kothottil, a Senior Engineering Manager on the SQL Server SEALS team.
Both Harini and Dinek are in the studio today to show off a new tool currently in preview called the Database Experimentation Assistant, a tool that enables migrating from a lower version of SQL Server to the latest version of SQL Server. However, it is much different than the Data Migration Assistant in that the Database Experimentation Assistant provides clarity into the complexity and risks of upgrading.
Harini and Dinek explain that the DEA focus is on key upgrade and migration areas such as understanding breaking changes or performance implications through looking at production workload comparisons between your current version and SQL Server 2016.
At the [03:15] mark we get into the high-level architecture and how the Data Experimentation Assistant to capture, replay, and analyzes workloads across SQL Server versions. Harini and Dinek explain how this works and what to expect during the process.
At the [05:35] mark it is DEMO TIME! Dinek spends the remaining 15 minutes of the show demoing the Database Experimentation Assistant tool, including capturing a trace, replaying the trace, and interrogating traces and tests to gain insights into the workload comparisons.
The DEA is a GREAT tool and we look forward to having Harini and Dinek back to provide updates to the tool. They are also looking for feedback on the tool, so download it and provide feedback via the links below!
You can download the latest DEA from here: https://www.microsoft.com/en-us/download/details.aspx?id=54090