ApsaraDB RDS for SQL Server offers a wide range of performance metrics. You can view standard monitoring data for an instance in the ApsaraDB RDS console, including the SQL Server service process, database metrics, and infrastructure monitoring.
Feature overview
ApsaraDB RDS for SQL Server has upgraded its Standard Monitoring feature. This feature integrates Performance Trend and offers additional capabilities.
In Standard Monitoring, you can view the following metrics:
Metric Classification | Metric |
SQL Server service process | SQLServer CPU utilization, IOPS, instance space, instance disk usage |
Database metrics | QPS, Connections, SQLServer_Transactions, SQLServer_NetworkTraffic |
Infrastructure monitoring | SQLServer_BufferHit, full table scans, SQL compilations per second, pages written by checkpoint per second, logons per second, lock timeouts per second, deadlocks per second, lock waits per second |
View standard monitoring
Log on to the ApsaraDB RDS console and go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the instance ID.
In the navigation pane on the left, click Monitoring and Alerts.
On the Standard Monitoring page, select the Standard View or Custom View tab.
Standard view
On the Standard View tab, you can select a time range to view Performance Events and Performance Metrics within that range.
NoteWhen you select a time range, the interval between the start time and the end time cannot be longer than 7 days. You can view data from the last 30 days.
View performance events
In the event statistics area, you can view the statistics for different types of events within the selected time range. Click View Details to go to the View Performance Events page. On this page, you can view details about anomalous activities and optimization events for the instance, including scheduled, running, and completed events.
View performance metrics
View monitoring metrics
Click More Metrics and select the metrics for which you want to view performance trends.
Click
next to each metric to view the sub-metrics it contains.In a metric trend chart, click Details to zoom in, modify the time range, and view the trend.
Click Add Trend Comparison to compare the performance trends of the same metric across different time ranges.
Diagnose and analyze metrics
In any metric trend chart, you can drag the mouse to select a time period. Then, you can Diagnose the selected period.
Custom view
On the Custom View tab, you can click Add Dashboard to create a custom dashboard that displays the trends of the metrics you want to monitor. For more information about the performance parameters that correspond to the metrics, see Performance parameters.
Click Add Node and Metric Monitoring to select the nodes and metrics to monitor on the dashboard.
You can choose how to display the metrics: Merged Display and Separate Display.
Merged Display: Multiple metrics are displayed in the same trend chart.
Separate Display: Each metric is displayed in its own trend chart.
You can use Chart Layout to set the number of metric trend charts displayed per row.
In a metric trend chart, click Details to zoom in, modify the time range, and view the trend.