Migrating SQL Workloads? Check out Database Experimentation Assistant
Considering the impact of a SQL upgrade? In this post, Application Development Manager Omer Amin spotlights Database Experimentation Assistant (DEA). 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 analysis metrics to help them build higher confidence, making it a successful upgrade experience.
Often, I am asked what the impact would be to upgrade to a new version of SQL. Microsoft does an amazing job, but short of scouring the release notes or deploying to the new version and running a full test, it was very difficult to come up with a good impact assessment.
The SQL team just released a new Experimentation Assistant.
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.
Premier Support for Developers provides strategic technology guidance, critical support coverage, and a range of essential services to help teams optimize development lifecycles and improve software quality. Contact your Application Development Manager (ADM) or email us to learn more about what we can do for you.