Database Autonomy Service (DAS) provides the Performance Trend feature. This feature offers comprehensive performance monitoring metrics, supports custom charts, and has powerful diagnostics capabilities that allow you to run manual diagnostics for a selected time period. This helps you assess the health of your database instance.
Prerequisites
The target database instance is connected to DAS, and its connection status is Normal. For more information, see Connect an instance.
Features
The Performance Trend feature includes metrics such as Transaction Per Second (TPS), queries per second (QPS), and throughput.
The monitoring granularity, or frequency, of metrics depends on the query time range. A wider time range results in a coarser granularity.
Procedure
Log on to the DAS console.
In the navigation pane on the left, click .
Find the target instance and click the instance ID to open the instance details page.
In the navigation pane on the left, click Dashboard.
On the Performance Trends page, you can view the performance trends of each metric for the selected time period.
Click More Metrics to select which metric trends to display.
NoteIn the metric trend graph, click the
icon next to a metric to view its description.In the metric trends graph, drag your mouse to select a time range to run a Diagnose.
On the Performance Trend Comparison page, you can compare the performance trends of the same metrics over different time ranges.
Click More Metrics to select the metrics for performance trend comparison.
On the Custom Charts page, you can create custom monitoring dashboards. You can add multiple performance metrics to the same chart for easier troubleshooting and analysis.
Click Add Monitoring Dashboard, enter a Dashboard Name, and click OK.
Click Add Node and Metrics, select the target nodes and the metrics to view, and then click the
icon.Click OK.