Tuning Report

Scenarios

The diagnosis report displays the data in the database in a specified period, such as the real-time performance data, session statistics, slow SQL statements, and SQL tuning content.

Prerequisites

  • You have obtained the process permission.

Procedures

  1. On the top menu bar, choose CloudDBA > Tuning Report.

    Figure 1 Tuning Report

  2. On the displayed page, click Start Diagnosis. In the displayed dialog box, set duration and frequency and click OK.
  3. Search for diagnosis reports by time range. Click View Report in the Operation column to view report details.
  4. On the details page, view metrics such as thread_conn, QPS, and com_del in real time. You can analyze the diagnosis based on performance data, session statistics, slow SQL statements, and SQL tuning content, and download the diagnosis report.

    Figure 2 Diagnosis details