Updated on 2025-09-01 GMT+08:00

RDS for SQL Server Metrics

Description

This section describes namespaces, descriptions, and dimensions of metrics reported by RDS for SQL Server to Cloud Eye. You can use APIs provided by Cloud Eye to retrieve metrics and alarms generated for RDS for SQL Server.

Namespace

SYS.RDS

Metrics

Table 1 RDS for SQL Server metrics

Metric ID

Name

Description

Value Range

Monitored Object and Instance Type

rds001_cpu_util

CPU Usage

CPU usage of the monitored object

0–100%

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds002_mem_util

Memory Usage

Memory usage of the monitored object

0–100%

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds003_iops

IOPS

Average number of I/O requests processed by the system in a specified period

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds004_bytes_in

Network Input Throughput

Incoming traffic in bytes per second

≥ 0 bytes/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds005_bytes_out

Network Output Throughput

Outgoing traffic in bytes per second

≥ 0 bytes/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds039_disk_util

Storage Space Usage

Storage space usage of the monitored object

0–100%

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds047_disk_total_size

Total Storage Space

Total storage space of the monitored object

40–4000, in GB

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds048_disk_used_size

Used Storage Space

Used storage space of the monitored object

0–4000, in GB

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds049_disk_read_throughput

Disk Read Throughput

Number of bytes read from the disk per second

≥ 0 bytes/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds050_disk_write_throughput

Disk Write Throughput

Number of bytes written into the disk per second

≥ 0 bytes/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds053_avg_disk_queue_length

Average Disk Queue Length

Number of processes to be written into the monitored object

≥ 0 counts

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds054_db_connections_in_use

Database Connections in Use

Number of database connections in use

≥ 0 counts

Monitored object: database

Monitored instance type: RDS for SQL Server instance

rds055_transactions_per_sec

Transactions per Second

Number of transactions started for the database per second

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds056_batch_per_sec

Batches per Second

Number of Transact-SQL command batches received per second

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds057_logins_per_sec

Logins per Second

Total number of logins started per second

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds058_logouts_per_sec

Logouts per Second

Total number of logouts started per second

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds059_cache_hit_ratio

Cache Hit Ratio

Ratio of pages found in the buffer cache without having to read from the disk to total pages

0–100%

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds060_sql_compilations_per_sec

SQL Compilations per Second

Number of SQL compilations per second

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds061_sql_recompilations_per_sec

SQL Recompilations per Second

Number of SQL recompilations per second

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds062_full_scans_per_sec

Full Scans per Second

Number of unrestricted full scans per second

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds063_errors_per_sec

Errors per Second

Number of errors per second

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds064_latch_waits_per_sec

Latch Waits per Second

Number of latch requests that have not been granted immediately

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds065_lock_waits_per_sec

Lock Waits per Second

Number of lock wait requests per second

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds066_lock_requests_per_sec

Lock Requests per Second

Number of new locks and lock conversions per second requested from the lock manager

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds067_timeouts_per_sec

Lock Timeouts per Second

Number of lock timeouts per second

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds068_avg_lock_wait_time

Average Lock Wait Time

Average wait time (ms) of lock requests

≥ 0 ms

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds069_deadlocks_per_sec

Deadlocks per Second

Number of deadlocks per second

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds070_checkpoint_pages_per_sec

Checkpoint Pages per Second

Number of pages flushed to the disk per second by a checkpoint or other operations that require all dirty pages to be flushed

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

rds077_replication_delay

Replication Delay

Delay for replication between primary and standby DB instances. The replication delay of RDS for SQL Server DB instances is at the database level because data is synchronized on each database. The instance-level replication delay refers to the maximum replication delay of the databases (the delay 0s for single-node DB instances).

≥ 0s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

mssql_mem_grant_pending

Memory Grants Pending

Total number of processes waiting for a workspace memory grant

≥ 0 counts

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

mssql_lazy_write_per_sec

Lazy Writes per Second

Number of lazy writes per second

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

mssql_page_life_expectancy

Page Life Expectancy

Number of seconds a page will stay in the buffer pool without references

≥ 0s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

mssql_page_reads_per_sec

Page Reads per Second

Number of page reads per second

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

mssql_tempdb_disk_size

Temporary Tablespace Size

Disk space occupied by the current temporary tablespace

≥ 0 MB

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

mssql_worker_threads_usage_rate

Usage of Worker Threads

Ratio of the total worker threads to the value of Max Worker Threads

0–100%

Monitored object: ECS

Monitored instance type: RDS for SQL Server instance

Dimension

Key

Value

rds_cluster_sqlserver_id

RDS for SQL Server instance ID

API Calling

Use APIs to search for RDS monitoring metrics. For details about calling methods and parameter description, see Querying Monitoring Data in the Cloud Eye API Reference.

Examples:

  • Request
/V1.0/{project_id}/metric-data?namespace=SYS.RDS&metric_name=rds001_cpu_util&dim.0=rds_cluster_id,5ea170ad-cc6b-49cd-9020-e94fdbeea391&from=1484123686000&to=1568188853000&period=300&filter=average
  • Response:
{
    "datapoints": [
        {
            "average": 0.35, 
            "timestamp": 1484123400000, 
            "unit": "Ratio"
        },
        {
            "average": 0.11, 
            "timestamp": 1484123700000, 
            "unit": "Ratio"
        }
    ], 
    "metric_name": "rds001_cpu_util",
    "httpcode" : 200,
    "header" : {
    "Transfer-Encoding" : "chunked",
    "Server" : "Web Server",
    "X-Request-Id" : "te-I-CES-APISVR25.id-0418d62a-1e76-46ff-9a5f-9ce40b336e29.ts-1484123744291.c-15046",
    "X-Content-Type-Options" : "nosniff",
    "Connection" : "keep-alive",
    "X-Download-Options" : "noopen",
    "Date" : "Wed, 11 Jan 2017 08:35:44 GMT",
    "X-Frame-Options" : "DENY",
    "Strict-Transport-Security" : "max-age=31536000; includeSubdomains;",
    "Cache-Control" : "no-cache",
    "X-XSS-Protection" : "1; mode=block;",
    "Content-Length" : "165",
    "Content-Type" : "application/json"
}
}