This topic shows you how to view the SQL analysis of an application.

Limits

Enterprise Distributed Application Service (EDAS) supports SQL analysis in Professional Edition and Platinum Edition, but not in Standard Edition.

Go to the feature page

  1. Log on to the EDAS console.
  2. Go to the Application Overview page by using one of the following methods:
    • In the left-side navigation pane, choose Resource Management > Container Service Kubernetes Clusters or Resource Management > Serverless Kubernetes Clusters. In the top navigation bar, select a region. In the upper part of the page, select a microservice namespace. On the Container Service Kubernetes Clusters or Serverless Kubernetes Clusters page, click a cluster ID. In the Applications section of the Cluster Details page, click the name of the application that you want to manage.
    • In the left-side navigation pane, click Applications. In the top navigation bar, select a region. In the upper part of the page, select a microservice namespace. Select Container Service or Serverless Kubernetes Cluster from the Cluster Type drop-down list and click the name of the application that you want to manage.
  3. In the left-side navigation pane of the application details page, choose Monitor > Instance Details.
  4. In the left-side pane of the Instance Details page, select the instance that you want to view and click the SQL Analysis tab on the right side of the page.

SQL call statistics

In the SQL Calls section, a time series curve indicates the SQL call statistics of the application in the specified time period.

Optional:In the SQL Calls section, perform the following operations as needed:
  • Move the cursor over the statistics chart to view the statistics.
  • Click chartIcon to view the statistics of the metric in a certain time period or compare the statistics of the same time period on different dates.

SQL statement list

The SQL statement list displays all SQL statements that are executed in the application in the specified time period.

SQL statement list
Optional:In the SQL statement list, perform the following operations as required:
  • To view the time series curve of the SQL call statistics of an SQL statement, click Invocation Statistics in the Actions column of the SQL statement.
  • To view the snapshots of the operation that is called by an SQL statement, click Interface Snapshot in the Actions column of the SQL statement.

    For more information, see Operation snapshot.