SQL Server database migration performance testing

Migrating database is always critical job for Database Administrators, usually which ends into bad performance of same database on newer version of SQL Server. Reason for this problem can be million but general reason is, it is because of growing data size.
Tool Used:
1. Data Migration Assistant (DMA): Gives us early prediction about things which are going to break in newer SQL Server version.
2. Database Experimentation Assistant (DEA): Helps into performance testing (workload testing) before migration.

What you need?
1. 3 Mock servers:
a. 1st server will need to have existing production environment configuration.
b. 2nd server will have configuration same as new production environment.
c. 3rd server will replay the workload on both the servers.
2. Point in time backup of production database.
3. Capturing workload trace from production.
4. Processing captured workload for replay.
Command:2 dreplay preprocess -m . -i "C:\Trace\Trace.trc" -d "C:\Trace\Preprocess"
5. Replaying workload on server 1st and 2nd from server 3rd.
Command: dreplay replay -m yogeshmehla -d "C:\Trace\Preprocess" -o -s yogeshmehla -w yogeshmehlas
6. Capturing replay workload.
7. Creating DEA report.
8. Cleaning captured replay try by clear trace.
9. Creating general report from clean trace data.