Performance Trend

Updated at:

Database Autonomy Service (DAS) provides the Performance Trend feature. You can view performance trends by time range, compare trends, and create custom views. This topic describes how to use this feature.

Prerequisites

The target database instance is connected to DAS, and its connection status is Normal.

Feature overview

  • Performance Trends includes metrics such as TPS, QPS, and throughput.

  • The data granularity of metrics in Performance Trends depends on the selected time range. The granularity becomes coarser as the time range increases.

Procedure

  1. Log on to the DAS console.

  2. In the navigation pane on the left, click Intelligent O&M Center > Instance Monitoring .

  3. Find the target instance and click the instance ID to open the instance details page.

  4. In the navigation pane on the left, click Dashboard.

    • Node

      For a cluster, you can choose to display metrics for a Standalone or Multi-Node.

    • Real-time mode

      To the left of the time selector are a blue Play icon, a Last 10 minutes preset, and the specific start and end times.

      Click the image icon on the right side of the time selector and then click OK in the subsequent dialog box to enable real-time mode and view live metrics.

      Click the image icon on the right side of the time selector to turn off real-time mode.

    • Monitoring view

      You can select a metrics dashboard. Currently, only the DAS standard view is supported.

    • Data granularity

      The available options are 5 seconds, 30 seconds, and minute.

      You can select a data granularity to view metrics at different levels of detail.

    • Columns

      Click the Columns drop-down list to change the number of charts displayed per row.

    • Compact display

      Enable the Compact Display switch for a more condensed view.

    • Linked cursors

      Enable the linked cursors toggle. When you hover over one chart, cursors appear on all other charts to show data for the same point in time.

      image

    • Diagnosis

      Click the Diagnose button in the upper-right corner of the chart area to run a diagnosis on the current view.

      image

      After the diagnosis completes, the panel displays an overall status, such as Normal, and a summary message like "0 issues found". Results are categorized under four items: resource, session, slow request, and all requests. A green checkmark indicates a normal status for an item. To run the diagnosis again, click Re-diagnose. For more information, click the Details link next to any item.