All Products
Search

This Product

    ApsaraDB RDS:View standard monitoring

    Document Center

    ApsaraDB RDS:View standard monitoring

    Last Updated:Nov 27, 2025

    ApsaraDB RDS for SQL Server offers a comprehensive set of performance monitoring metrics. You can view standard monitoring data for an instance, including basic and database metrics, in the RDS console.

    Features

    ApsaraDB RDS for SQL Server has upgraded the Standard Monitoring page. This page now integrates the Performance Trend feature and provides additional features. On the Standard Monitoring page, you can view the following metrics:

    Metric classification

    Metrics

    Basic metrics

    CPU/Memory Usage, IOPS Utilization, IOPS, Instance Storage, Instance Disk Usage, Network Traffic, Throughput Utilization, Throughput

    Database metrics

    QPS, Connections, Transactions, SQLServer_BufferHit, Full Table Scan Rate, SQL Compilation Rate, Checkpoint Pages Written, Logons, Lock Timeouts, Deadlocks, Lock Wait Times, SQL Server AlwaysOn Replication Lag (Cluster Edition only), Page Life Expectancy

    View standard monitoring

    1. 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.

    2. In the navigation pane on the left, click Monitoring and Alerts.

    3. On the Standard Monitoring page, you can perform the following operations:

      Note

      If the monitoring page does not show Basic Metrics and Database Metrics, you may be on the old version of the page. Click Previous Version in the upper-right corner.

      • Query monitoring metrics for a specific time period

        Select a time range to view the corresponding metrics. You can query monitoring data for the last 30 days.

        image

      • Enable real-time mode

        Click image before the time range box to enable real-time mode. The system then auto-refreshes the metrics every 5 seconds. This lets you view real-time changes in database performance.

      • Change the monitoring frequency

        You can set Data Granularity to view metric trends at a different time granularity, such as 5 seconds, 30 seconds, or 1 minute.

      • View metric descriptions

        In the metric trends graph, you can click 指标.png after each metric to view the sub-metrics and their descriptions.

      • Switch nodes

        For ApsaraDB RDS for SQL Server instances of the Cluster Edition, you can select one or more nodes to view. This lets you compare and analyze metrics across different nodes.

    Metric descriptions

    Basic metrics

    Metric

    Metric name

    Unit

    Description

    CPU/Memory Usage

    cpu_usage

    %

    CPU usage of the instance as a percentage of the total operating system CPU.

    mem_usage

    %

    Instance memory usage.

    IOPS Utilization

    iops_usage_no_burst

    %

    The IOPS usage if I/O burst is disabled for the instance.

    iops_usage_burst

    %

    The actual IOPS usage.

    iops_usage_burst_ratio

    %

    The percentage of IOPS improvement after I/O burst is enabled.

    IOPS

    db_io_read

    Count

    The number of read I/O requests per second.

    db_io

    Count

    The number of I/O requests per second.

    db_io_write

    Count

    The number of write I/O requests per second.

    iops_of_ecs

    Count

    The upper limit of IOPS on the computing side.

    iops_of_disk

    Count

    The upper limit of IOPS on the storage side.

    iops_no_burst

    Count

    The upper limit of IOPS if I/O burst is disabled for the instance.

    iops_burst

    Count

    The upper limit of IOPS.

    Instance Storage

    disk_mastersize

    MB

    The disk space occupied by the SQL Server system database master.

    disk_modelsize

    MB

    The disk space occupied by the model database. The model database is the template for each new database.

    disk_msdbsize

    MB

    The disk space occupied by the msdb database. The msdb database is used to manage SQL Server Agent jobs and backup history information.

    disk_errorlog

    MB

    The disk space occupied by error log files. You can clear the error logs of the instance in the console or by calling an API operation.

    disk_xel

    MB

    The disk space occupied by Extended Event log files.

    disk_trace

    MB

    The disk space used to store SQL Server trace files, such as SQL Profiler trace files.

    disk_dump

    MB

    The space occupied by dump files that are generated when the SQL Server kernel encounters an exception.

    log_size

    MB

    The amount of log space used.

    ins_size

    MB

    The total amount of space used by the instance.

    tmp_size

    MB

    The amount of temporary space used.

    data_size

    MB

    The amount of data space used.

    other_size

    MB

    The amount of system space used.

    Instance Disk Usage

    disk_usage

    %

    The disk space usage.

    Network Traffic

    write_kb

    KB

    The average inbound traffic of the instance per second.

    read_kb

    KB

    The average outbound traffic of the instance per second.

    Throughput Utilization

    mBps_usage_burst

    %

    The actual disk I/O throughput usage.

    mBps_usage_no_burst

    %

    The disk I/O throughput usage if I/O burst is disabled for the instance.

    mBps_burst_ratio

    %

    The percentage of disk I/O throughput improvement after I/O burst is enabled.

    Throughput

    mBps_total

    MB/s

    The disk I/O throughput per second.

    mBps_read

    MB/s

    The disk read I/O throughput per second.

    mBps_write

    MB/s

    The disk write I/O throughput per second.

    mBps_of_ecs

    MB/s

    The upper limit of disk I/O throughput per second on the computing side.

    mBps_of_disk

    MB/s

    The upper limit of disk I/O throughput per second on the storage side.

    mBps_no_burst

    MB/s

    The upper limit of disk I/O throughput per second if I/O burst is disabled for the instance.

    mBps_burst

    MB/s

    The upper limit of disk I/O throughput per second.

    Database metrics

    Metric

    Metric name

    Unit

    Description

    QPS

    qps

    Count

    The average number of SQL statements that are executed per second.

    Connections

    connection_reset

    Count

    The total number of logons that are initiated from the connection pool per second.

    active_temp_tables

    Count

    The number of active temporary tables.

    active_session

    Count

    The number of active threads.

    active_cursors

    Count

    The number of active cursors.

    sessions

    Count

    The total number of connections.

    active_transactions

    Count

    The number of active transactions.

    Transactions

    transactions

    Count

    The average number of transactions per second.

    write_transactions

    Count

    The average number of write transactions per second.

    SQLServer_BufferHit

    cache_hit_ratio

    %

    The cache hit ratio.

    bufferpool_hit_ratio

    %

    The percentage of pages that are found in the buffer cache without having to be read from the disk.

    Full Table Scan Rate

    fullscans

    %

    The average number of full table scans per second.

    SQL Compilation Rate

    autoparam_attempts_per_sec

    Count

    The number of auto-parameterization attempts per second.

    forced_parameterizations_per_sec

    Count

    The number of successful forced parameterizations per second.

    sql_compilations

    Count

    The number of SQL compilations per second.

    unsafe_autoparams_per_sec

    Count

    The number of unsafe auto-parameterization attempts per second.

    failed_autoparams_per_sec

    Count

    The number of failed auto-parameterization attempts per second.

    safe_autoparams_per_sec

    Count

    The number of safe auto-parameterization attempts per second.

    resqlcompilations

    Count

    The number of statement recompilations per second.

    Checkpoint Pages Written

    lazy_writes

    Count

    The number of writes to the disk per second.

    checkpoint

    Count

    The number of pages written to the disk by checkpoints per second.

    Logons

    logout

    Count

    The number of logouts per second.

    logins

    Count

    The number of logons per second.

    Lock Timeouts

    locktimeout

    Count

    The number of lock requests that timed out per second. This includes requests for NOWAIT locks.

    Deadlocks

    deadlock

    Count

    The number of deadlocks that occurred per second.

    Lock Wait Times

    average_latch_wait_time

    ms

    The average wait time for latch requests.

    table_lock_escalations_per_sec

    Count

    The number of times locks on a table were escalated to the TABLE or HoBT granularity.

    average_lock_wait_time

    ms

    The average wait time for lock requests.

    total_latch_wait_time_ms

    ms

    The total latch wait time in the last second.

    lock_requests_per_sec

    Count

    The number of new locks and lock conversions that are requested per second.

    lockwaits

    Count

    The number of lock requests per second for which the caller waited.

    latchwaits

    Count

    The number of latch requests that could not be granted immediately per second.

    lock_waits

    Count

    The statistics about processes that are waiting for a lock.

    lock_wait_time_ms

    ms

    The average lock wait time.

    SQL Server AlwaysOn Replication Lag

    ag_sync_lag_secs

    s

    This metric is displayed only for instances of the Cluster Edition. It indicates the SQL Server AlwaysOn replication lag.

    Page Life Expectancy

    Page_life_expectancy

    s

    The average time that a cached data page stays in memory.