Querying the Replay Progress

Prerequisites

• You have logged in to the DRS console.
• A workload replay task has been started.

Querying the Replay Progress

1. On the Workload Replay Management page, click the target replay task in the Task Name/ID column.
2. On the displayed page, click Workload Replay Progress to view task progress.
   • In the Workload Replay Progress area, you can view the task status, start time, total number of SQL statements, and number of replayed SQL statements.
   • 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 in a specified period.
   • In the Abnormal SQLs in Workload Replay area, you can view the category and number of SQL statements that fail to be replayed.
   • In the Slow SQLs area, you can view the original time and replay time required for executing a SQL statement.
   • In the SQL Execution Progress are, you can view the SQL statements that are executing in the destination database during replay.
     Figure 1 Workload replay progress
     

Downloading an Exported Report

Abnormal and slow SQL statements can be exported and download during workload replay.

1. On the Workload Replay Management page, click the target replay task in the Task Name/ID column.
2. On the displayed page, click Workload Replay Progress to view task progress.
3. In the Abnormal SQLs in Workload Replay and Slow SQLs areas on the Workload Replay Progress page, download reports for the task.
   1. Click on the right of the Abnormal SQLs in Workload Replay or Slow SQLs area to export the report.
   2. In the displayed dialog box, select the fields to be exported and click Export.
      Figure 2 Exporting a report
      

   3. After the export is complete, click to download the report.
      Figure 3 Downloading a report