Reviewing replay compare period reports enables you to determine if any replay divergence occurred and whether there were any significant performance changes.
Depending on the type of comparison that is being made, one of three types of replay compare period reports is generated:
Capture vs. Replay
This report type compares the performance of a workload replay to its workload capture.
Replay vs. Replay
This report type compares the performance of two workload replays of the same workload capture.
Consolidated Replay
This report type compares the performance of multiple workload captures to a consolidated replay. Only the ASH Data Comparison section is available for this report type. For more information about this report type, see "Reporting and Analysis for Consolidated Database Replay".
All replay compare period report types contain information about the most important changes between the two runs that are being compared. Use this information to determine the appropriate action to take. For example, if a new concurrency issue is found, review Automatic Database Diagnostic Monitor (ADDM) reports to diagnose the issue. If a new SQL performance problem is found, run SQL Tuning Advisor to fix the problem.
The information in the replay compare period report is divided into the following sections: