This topic describes how to view the resource and engine monitoring data of an RDS for SQL Server instance. ApsaraDB for RDS provides a wide range of performance metrics for you to view in the RDS console.

Procedure

  1. Log on to the RDS console.
  2. In the upper-left corner, select the region where the target RDS instance is located.
    选择地域
  3. Find the target RDS instance and click the instance ID.
  4. In the left-side navigation pane, click Monitoring and Alerts.
  5. On the Monitoring tab, select the Resource Monitoring or Engine Monitoring monitoring type and specify the time range. The following table describes the monitoring metrics.
    Monitoring type Metric Description
    Resource Monitoring Disk Space (MB) The disk space usage of the RDS instance, including:
    • Instance Size
    • Data Usage
    • Log Size
    • Temporary File Size
    • Other System File Size

    Unit: MByte.

    IOPS (Input/Output Operations per Second) The number of I/O requests per second for the RDS instance. Unit: Number/second.
    Total Connections The total number of connections to the RDS instance, including the number of active connections and the total number of connections.
    MSSQL Instance CPU Utilization (percentage in the operating system: %) The CPU usage of the RDS instance, including the CPU usage for the operating system.
    SQLServer Average Input/Output Traffic (KB/s) The input and output traffic of the RDS instance per second. Unit: KB.
    Engine Monitoring Average Transaction Frequency The number of transactions processed per second.
    Average QPS The number SQL statements executed per second.
    Buffer Hit Ratio (%) The read hit ratio of the buffer.
    Page Write Frequency at Check Point The number of pages that are written at the check point per second in the RDS instance.
    Login Frequency The number of logons to the RDS instance per second.
    Average Frequency of Whole Table Scans The number of full table scans performed per second.
    SQL Compilations per Second The number of SQL statements that are compiled per second in the RDS instance.
    Lock Timeout Times/s The number of times that the lock times out per second in the RDS instance.
    Deadlock Frequency The number of times that the RDS instance is locked per second.
    Lock Wait Frequency The number of times that the RDS instance enters the waiting state after being locked.