This topic describes how to view the resource and engine metrics of an ApsaraDB RDS for SQL Server instance in the ApsaraDB for RDS console.

Procedure

  1. Log on to the ApsaraDB for RDS console.
  2. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where the target RDS instance resides.
    Select a region
  3. Find the target 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 type and specify a time range. Then, you can view the metrics that appear. The following table describes the metrics.
    Monitoring type Metric Description
    Resource Monitoring Disk Space The disk usage of the RDS instance, including:
    • Instance size
    • Data usage
    • Log size
    • Temporary file size
    • Other system file size

    Unit: MB.

    IOPS The number of input/output operations per second (IOPS) for the RDS instance.
    Total Connections The total number of current connections to the RDS instance.
    MSSQL Instance CPU Utilization (percentage in the operating system: %) The CPU utilization of the RDS instance. This includes the CPU utilization for the operating system. Unit: %.
    SQLServer Average Input/Output Traffic The inbound and outbound traffic of the RDS instance. Unit: KB/second.
    Engine Monitoring Average Transaction Frequency The number of transactions processed per second.
    Average QPS The number of SQL statements executed per second
    Buffer Hit Ratio The read hit ratio of the buffer pool. Unit: %.
    Page Write Frequency at Check Point The number of checkpoints written to pages per second.
    Login Frequency The number of logons to the RDS instance per second.
    Average Frequency of Whole Table Scans The number of full table scans per second.
    SQL Compilations per Second The number of SQL statements compiled per second
    Lock Timeout Times The number of lock timeouts on the RDS instance per second.
    Deadlock Frequency The number of deadlocks on the RDS instance per second.
    Lock Wait Frequency The number of lock waits on the RDS instance per second.