Updated on 2024-09-25 GMT+08:00

Viewing the Replay Reporting

The replay reporting records the execution time curve of each SQL statement replayed in the destination database, number of replayed SQLs, and replay duration.

Prerequisites

You have logged in to the DRS console.

Viewing the Replay Reporting

  1. On the Workload Replay Management page, click the target replay task in the Task Name/ID column.
  2. On the Replay Reporting page, view the report information about the current task.

    • In the Statistics Chart area, you can view the total number of SQL statements, number of replayed SQL statements, number of abnormal SQL statements, and number of slow SQL statements replayed in the destination database in a specified period.
      Figure 1 Replay statistics chart
    • In the Slow SQLs area, you can view the number of SQL statements of each type and the replay duration.
    • In the Abnormal SQLs in Workload Replay area, you can view the category and number of SQL statements that fail to be replayed.
      Figure 2 SQLs to be replayed

Downloading a Replay Report

  1. On the Workload Replay Management page, click the target replay task in the Task Name/ID column.
  2. On the Replay Reporting page, download the replay report of the current task.

    1. Click on the right of the Slow SQLs or Abnormal SQLs in Workload Replay area to export the report.
    2. After the export is complete, click to download the report.
      Figure 3 Downloading a report