This topic describes how to view the performance assessment report generated after a performance assessment task is completed.
Limitations
You can view the performance assessment report only for a full performance assessment task or SQL file replay task that is in the Completed state.
Performance assessment reports are retained for at most 15 days.
Procedure
Log on to the OceanBase Cloud console.
In the left-side navigation pane, click Data Services > Migrations.
On the Migrations page, click the Assess Performance tab.
On the Assess Performance tab, click View Report next to the target assessment task.
On the Load Replay Report page, view details of the report.
Details in a report
A load replay report comprises the Replay Analysis and SQL Diagnostic Information modules.
The Replay Analysis module displays information in the following sections: Total Replays, Replay Success Rate, and Replay Traffic Comparison. In the Replay Traffic Comparison section, you can choose to compare replay traffic of the All, Select, or Write type.
If you select All and replay read-only traffic, the source traffic curve chart contains both write traffic and read traffic. In this case, it is normal if the target curve is lower than the source curve.
When you replay traffic at a speed that is a multiple of the original speed, the replay time is shorter than the traffic recording time in the source. In this case, the target curve in the replay traffic comparison chart drops to 0 at the end.
The SQL Diagnostic Information module displays information in the following tabs: TopSQL and SlowSQL. You can view the SQL text, database accessed by the SQL statement, CPU utilization, SQL ID, total number of executions within the specified period, total time (in ms) consumed by the database in executing the SQL statement, and error summary. In the upper-right corner of this section, you can filter the information that you want to check.