Test and optimize SQL Server databases using the Database Experimentation Assistant (DEA)
The Database Experimentation Assistant (DEA) is a standalone application that can compare workloads between the current version of your database, and the target.
Learning objectives
In this module, you will:
- Decide if DEA is the right tool for your workload testing
- Install DEA on your client machine
- Test a typical workload on an upgraded database
- Review the results of a trace analysis report
Prerequisites
- Experience administering SQL Server databases
- Knowledge of SQL Server Profiler and trace files
- Understanding of database performance