Trace Id is missing

Unlock your potential with Microsoft Copilot

Get things done faster and unleash your creativity with the power of AI anywhere you go.
Microsoft Copilot app being utilized to generate pictures of a singing dog, assisting to identify a flower, and helping to generate an email to congratulate a coworker on a promotion.

Microsoft® Database Experimentation Assistant 2.6

Database Experimentation Assistant (DEA) is a new A/B testing 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 (SQL Server 2005 and above) to any new version of the SQL Server will be able to use these analysis metrics.

Important! Selecting a language below will dynamically change the complete page content to that language.

  • Version:


    Date Published:


    File Name:


    File Size:

    54.1 MB

    KB Articles:


    This version of DEA offers the following capabilities.
    • Capture and replay of production database workloads through automated setup.
    • Support for server side traces and XEvents.
    • Perform statistical analysis on traces and/or XEvents collected using both old and new instances.
    • Visualize data through analysis report via rich user experience.
    • Ability to use SQL Authentication to both capture and replay.
    • An Inbuilt replay tool in addition to already supported SQL Server Distributed Replay for simple workloads.
    • Removed the dependencies of R and R-Interop.
    • Ability to capture and replay on Azure SQL Database, Azure SQL Managed Instance and SQL Server on Linux.
    • Reporting improvements.
    • Bug fixes and other performance improvements.
  • Supported Operating Systems

    Windows 10, Windows 8, Windows 8.1, Windows Server 2012, Windows Server 2016

    Windows Server 2016, Windows Server 2012, Windows 10, Windows 8.1 NET Framework 4.5 64-bit or above SQL Server 2014 or above
  • Download and run 'DatabaseExperimentationAssistant.exe'

Follow Microsoft