Optimization suggestions

You can quickly view the SQL-class and structural-class optimization suggestions for each tenant through the optimization suggestion feature.

Prerequisites

You have completed one-click diagnostics and generated a diagnostic report. If not, please refer to Initiate one-click diagnostics.

Procedure

1. In the Diagnostic Report section, click Optimization Suggestions.

2. At the top of the Optimization Suggestions section, view the Number of SQL that can be optimized and Number of structures that can be optimized. Click View More to jump to the Optimization Suggestion tab of the real-time diagnostics feature.

3. In the Optimization Suggestion section, view the SQL Class and Structural Class optimization suggestions and diagnostic reasons.

   • On the SQL Class tab, view the Optimization Object, SQL ID, Optimization Type, Tenant Name, Database, CPU Percentage (%), Response Time Percentage (%), Diagnostic Reason, and Optimization Suggestions.

   • On the Structural Class tab, view the Optimization Object, Optimization Type, Tenant Name, Database, Diagnostic Reason, and Optimization Suggestions.