Test and optimize SQL Server databases using the Database Experimentation Assistant (DEA)

Beginner
Administrator
SQL Server

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