Database Autonomy Service (DAS) provides the monitoring dashboard feature for ApsaraDB RDS for SQL Server. DAS allows you to specify RDS instances and metrics to monitor and compare the metrics of the RDS instances. You can also configure metric linkage. This helps you understand the status of ApsaraDB RDS for SQL Server instances.

Background information

DAS provides the monitoring dashboard feature for ApsaraDB RDS for SQL Server from May 20, 2022.

Create a monitoring dashboard

  1. Log on to the ApsaraDB RDS console.
  2. In the left-side navigation pane, click Performance Center.
  3. On the Performance Center page, click the Monitoring Dashboard tab.
  4. Click the tab for the database engine. Then, click Add Monitoring Dashboard.
  5. In the dialog box that appears, configure the Dashboard Name parameter and click OK.
  6. Click Select Instances and Metrics. In the dialog box that appears, select the RDS instances and the metrics that you want to monitor. Then, click the Rightwards arrow icon to add the selected RDS instances to the Selected Instances section and the selected metrics to the Selected Metrics section.
    Note
    • You can select up to 32 RDS instances at a time.
    • For more information about the metrics, see Metrics.
    Select Metrics and Instances dialog box
  7. Click Confirm.
    Note To modify the RDS instances or metrics in the monitoring dashboard, click Add Instances and Metrics.

View the metric trends of an RDS instance in the monitoring dashboard

  1. Log on to the ApsaraDB RDS console.
  2. In the left-side navigation pane, click Performance Center.
  3. On the Performance Center page, click the Monitoring Dashboard tab.
  4. Click the tab for the database engine, select the monitoring dashboard that you want to view, and then specify a time range to view the trend charts of the metrics during the specified time range.
    Note When you specify a time range, the end time must be later than the start time, and the interval between the start time and the end time cannot exceed seven days.
    • You can configure the Instance filtering parameter to filter for multiple RDS instances and then view and compare the metrics of the RDS instances.
    • You can turn on Auto Refresh (Every 5 Seconds) for the system to refresh the trend charts of the metrics every 5 seconds.
    • You can turn on Linkage Chart to view the values of different metrics at the same point in time.
    • You can configure the Chart Layout parameter to specify the number of trend charts of metrics in each row.
    • You can click Add Instances and Metrics to modify the RDS instances or metrics in the dashboard.
    • You can click Details in the trend chart of a metric to expand the chart. You can also change the time range to view the changes in the trend of the metric at the specified time range.
    • You can click Delete in the trend chart of a metric to delete the chart from the dashboard.

Metrics

CategoryMetricDescription
SQL Server processcpu_usageThe CPU utilization of the RDS instance within the operating system.
db_ioThe number of I/O requests per second.
db_io_readThe number of read I/O requests per second.
db_io_writeThe number of write I/O requests per second.
other_sizeThe amount of disk space occupied by system files
log_sizeThe amount of disk space occupied by log files.
tmp_sizeThe amount of disk space occupied by temporary files.
ins_sizeThe total amount of disk space occupied by the RDS instance.
data_sizeThe amount of disk space occupied by data files.
DatabaseqpsThe average number of times that SQL statements are executed per second.
connection_resetThe total number of logon attempts from the connection pool per second.
active_temp_tablesThe number of active temporary tables.
active_sessionThe number of active threads.
active_cursorsThe number of active cursors.
sessionsThe total number of connections.
active_transactionsThe number of active transactions.
transactionsThe average number of transactions per second.
write_transactionsThe average number of write transactions per second.
read_kbThe outbound traffic per second of the RDS instance.
write_kbThe inbound traffic per second of the RDS instance.
Basic monitoringcache_hit_ratioThe hit ratio of the high-speed cache.
bufferpoolThe percentage of pages that are found in the high-speed cache to all pages that are read from disks.
fullscansThe average number of full table scans per second.
autoparam_attempts_per_secThe number of auto parameterization attempts per second.
forced_parameterizations_per_secThe number of successful forced parameterizations per second.
sql_compilationsThe number of SQL compilations per second.
unsafe_autoparams_per_secThe number of unsafe auto parameterization attempts per second.
failed_autoparams_per_secThe number of auto parameterization failures per second.
safe_autoparams_per_secThe number of safe auto parameterization attempts per second.
resqlcompilationsThe number of SQL statement recompilations per second.
lazy_writesThe number of times that dirty pages are written to disks per second.
checkpointThe number of dirty pages that the checkpoint operation must write per second.
logoutThe number of logouts per second.
loginsThe number of logons per second.
locktimeoutThe number of lock requests that time out per second, including requests for NOWAIT locks.
deadlock The number of lock requests that resulted in a deadlock per second.
lock_requests_per_secThe number of new locks and lock conversions per second.
lockwaitsThe number of lock requests that the client waits for per second.
lock_waitsThe statistics of processes waiting for locks.
latchwaitsThe number of latch requests that are not immediately granted per second.
lock_wait_time_msThe average amount of wait time for each lock request that resulted in a wait.
average_latch_wait_timeThe average waiting time to request a latch resource.
table_lock_escalations_per_secThe number of times that a lock on a table is escalated to the HoBT level or the table level.
average_lock_wait_timeThe average waiting time of the requested lock resource.
total_latch_wait_timeThe total waiting time for locks in the last second.
Note You can click the Info icon icon on the right of a metric in a dashboard to view the description of the metric.