Configuring Displayed Metrics
The RDS Agent monitors RDS DB instances and collects monitoring metrics only.
Description
This section describes the metrics that can be monitored by Cloud Eye as well as their namespaces and dimensions. You can use APIs provided by Cloud Eye to query the monitoring metrics and alarms generated for RDS.
Namespace
SYS.RDS
DB Instance Monitoring Metrics
| Metric ID | Name | Description | Value Range | Monitored Object | Monitoring Interval (Raw Data) |
|---|---|---|---|---|---|
| rds001_cpu_util | CPU Usage | CPU usage of the monitored object | 0%–100% | RDS for SQL Server instance | 1 minute |
| rds003_iops | IOPS | Average number of I/O requests processed by the system in a specified period | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| rds039_disk_util | Storage Space Usage | Storage space usage of the monitored object | 0%–100% | RDS for SQL Server instance | 1 minute |
| rds002_mem_util | Memory Usage | Memory usage of the monitored object | 0%–100% | RDS for SQL Server instance | 1 minute |
| rds004_bytes_in | Network Input Throughput | Incoming traffic in bytes per second | ≥ 0 bytes/s | RDS for SQL Server instance | 1 minute |
| rds005_bytes_out | Network Output Throughput | Outgoing traffic in bytes per second | ≥ 0 bytes/s | RDS for SQL Server instance | 1 minute |
| rds049_disk_read_throughput | Disk Read Throughput | Number of bytes read from the disk per second | ≥ 0 bytes/s | RDS for SQL Server instance | 1 minute |
| rds050_disk_write_throughput | Disk Write Throughput | Number of bytes written into the disk per second | ≥ 0 bytes/s | RDS for SQL Server instance | 1 minute |
| rds047_disk_total_size | Total Storage Space | Total storage space of the monitored object | 40–4,000 GB | RDS for SQL Server instance | 1 minute |
| rds048_disk_used_size | Used Storage Space | Used storage space of the monitored object | 0–4,000 GB | RDS for SQL Server instance | 1 minute |
| rds053_avg_disk_queue_length | Average Disk Queue Length | Number of processes to be written into the monitored object | ≥ 0 | RDS for SQL Server instance | 1 minute |
| rds054_db_connections_in_use | Database Connections in Use | Number of database connections in use | ≥ 0 counts | RDS for SQL Server instance | 1 minute |
| rds055_transactions_per_sec | Transactions per Second | Number of transactions started for the database per second | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| rds056_batch_per_sec | Batches per Second | Number of Transact-SQL command batches received per second | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| rds057_logins_per_sec | Logins per Second | Total number of logins started per second | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| rds058_logouts_per_sec | Logouts per Second | Total number of logouts started per second | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| 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% | RDS for SQL Server instance | 1 minute |
| rds060_sql_compilations_per_sec | SQL Compilations per Second | Number of SQL compilations per second | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| rds061_sql_recompilations_per_sec | SQL Recompilations per Second | Number of SQL recompilations per second | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| rds062_full_scans_per_sec | Full Scans per Second | Number of unrestricted full scans per second | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| rds063_errors_per_sec | Errors per Second | Number of errors per second | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| rds064_latch_waits_per_sec | Latch Waits per Second | Number of latch requests that have not been granted immediately | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| rds065_lock_waits_per_sec | Lock Waits per Second | Number of lock wait requests per second | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| 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 | RDS for SQL Server instance | 1 minute |
| rds067_timeouts_per_sec | Lock Timeouts per Second | Number of lock timeouts per second | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| rds068_avg_lock_wait_time | Average Lock Wait Time | Average wait time (ms) of lock requests | ≥ 0 ms | RDS for SQL Server instance | 1 minute |
| rds069_deadlocks_per_sec | Deadlocks per Second | Number of deadlocks per second | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| 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 | RDS for SQL Server instance | 1 minute |
| 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 DB instances). | ≥ 0s | RDS for SQL Server instance | 1 minute |
| mssql_mem_grant_pending | Memory Grants Pending | Total number of processes waiting for a workspace memory grant | ≥0 counts | RDS for SQL Server instance | 1 minute |
| mssql_lazy_write_per_sec | Lazy Writes per Second | Number of lazy writes per second | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| mssql_page_life_expectancy | Page Life Expectancy | Number of seconds a page will stay in the buffer pool without references | ≥ 0s | RDS for SQL Server instance | 1 minute |
| mssql_page_reads_per_sec | Page Reads per Second | Number of page reads per second | ≥ 0 counts/s | RDS for SQL Server instance | 1 minute |
| mssql_tempdb_disk_size | Temporary Tablespace Size | Disk space occupied by the current temporary tablespace. | ≥ 0 MB | RDS for SQL Server instance | 1 minute |
Dimension
| Key | Value |
|---|---|
| rds_cluster_sqlserver_id | RDS for SQL Server instance ID |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
