Configuring Displayed Metrics

The RDS Agent monitors RDS DB instances and collects monitoring metrics only.

This section describes the metrics supported by RDS. It covers description, namespaces, monitoring metrics, and dimensions.

Description

This section describes the RDS for SQL Server 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 for SQL Server.

Namespace

SYS.RDS

DB Instance Monitoring Metrics

**Table 1** Performance metrics
Metric ID	Name	Description	Value Range	Unit	Conversion Rule	Dimension	Monitoring Interval (Raw Data)
rds001_cpu_util	CPU Usage	CPU usage of the monitored object	0–100	%	N/A	rds_cluster_sqlserver_id	1 minute
rds003_iops	IOPS	Average number of I/O requests processed by the system in a specified period	≥ 0	count/s	N/A	rds_cluster_sqlserver_id	1 minute
rds039_disk_util	Storage Space Usage	Storage space usage of the monitored object	0–100	%	N/A	rds_cluster_sqlserver_id	1 minute
rds002_mem_util	Memory Usage	Memory usage of the monitored object	0–100	%	N/A	rds_cluster_sqlserver_id	1 minute
rds004_bytes_in	Network Input Throughput	Incoming traffic in bytes per second	≥ 0	KiB/s	1024	rds_cluster_sqlserver_id	1 minute
rds005_bytes_out	Network Output Throughput	Outgoing traffic in bytes per second	≥ 0	KiB/s	1024	rds_cluster_sqlserver_id	1 minute
rds049_disk_read_throughput	Disk Read Throughput	Number of bytes read from the disk per second	≥ 0	Byte/s	1024	rds_cluster_sqlserver_id	1 minute
rds050_disk_write_throughput	Disk Write Throughput	Number of bytes written into the disk per second	≥ 0	Byte/s	1024	rds_cluster_sqlserver_id	1 minute
rds047_disk_total_size	Total Storage Space	Total storage space of the monitored object	40–4000	GiB	1024	rds_cluster_sqlserver_id	1 minute
rds048_disk_used_size	Used Storage Space	Used storage space of the monitored object	0–4000	GiB	1024	rds_cluster_sqlserver_id	1 minute
rds053_avg_disk_queue_length	Average Disk Queue Length	Number of processes to be written into the monitored object	≥ 0	count	N/A	rds_cluster_sqlserver_id	1 minute
rds054_db_connections_in_use	Database Connections in Use	Number of database connections in use	≥ 0	count	N/A	rds_cluster_sqlserver_id	1 minute
rds055_transactions_per_sec	Transactions per Second	Number of transactions started for the database per second	≥ 0	count/s	N/A	rds_cluster_sqlserver_id	1 minute
rds056_batch_per_sec	Batches per Second	Number of Transact-SQL command batches received per second	≥ 0	count/s	N/A	rds_cluster_sqlserver_id	1 minute
rds057_logins_per_sec	Logins per Second	Total number of logins started per second	≥ 0	count/s	N/A	rds_cluster_sqlserver_id	1 minute
rds058_logouts_per_sec	Logouts per Second	Total number of logouts started per second	≥ 0	count/s	N/A	rds_cluster_sqlserver_id	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	%	N/A	rds_cluster_sqlserver_id	1 minute
rds060_sql_compilations_per_sec	SQL Compilations per Second	Number of SQL compilations per second	≥ 0	count/s	N/A	rds_cluster_sqlserver_id	1 minute
rds061_sql_recompilations_per_sec	SQL Recompilations per Second	Number of SQL recompilations per second	≥ 0	count/s	N/A	rds_cluster_sqlserver_id	1 minute
rds062_full_scans_per_sec	Full Scans per Second	Number of unrestricted full scans per second	≥ 0	count/s	N/A	rds_cluster_sqlserver_id	1 minute
rds063_errors_per_sec	Errors per Second	Number of errors per second	≥ 0	count/s	N/A	rds_cluster_sqlserver_id	1 minute
rds064_latch_waits_per_sec	Latch Waits per Second	Number of latch requests that have not been granted immediately	≥ 0	count/s	N/A	rds_cluster_sqlserver_id	1 minute
rds065_lock_waits_per_sec	Lock Waits per Second	Number of lock wait requests per second	≥ 0	count/s	N/A	rds_cluster_sqlserver_id	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	count/s	N/A	rds_cluster_sqlserver_id	1 minute
rds067_timeouts_per_sec	Lock Timeouts per Second	Number of lock timeouts per second	≥ 0	count/s	N/A	rds_cluster_sqlserver_id	1 minute
rds068_avg_lock_wait_time	Average Lock Wait Time	Average wait time (ms) of lock requests	≥ 0	ms	N/A	rds_cluster_sqlserver_id	1 minute
rds069_deadlocks_per_sec	Deadlocks per Second	Number of deadlocks per second	≥ 0	count/s	N/A	rds_cluster_sqlserver_id	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	count/s	N/A	rds_cluster_sqlserver_id	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-node DB instances).	≥ 0	s	N/A	rds_cluster_sqlserver_id	1 minute
mssql_mem_grant_pending	Memory Grants Pending	Total number of processes waiting for a workspace memory grant	≥ 0	count	N/A	rds_cluster_sqlserver_id	1 minute
mssql_lazy_write_per_sec	Lazy Writes per Second	Number of lazy writes per second	≥ 0	count/s	N/A	rds_cluster_sqlserver_id	1 minute
mssql_page_life_expectancy	Page Life Expectancy	Number of seconds a page will stay in the buffer pool without references	≥ 0	s	N/A	rds_cluster_sqlserver_id	1 minute
mssql_page_reads_per_sec	Page Reads per Second	Number of page reads per second	≥ 0	count	N/A	rds_cluster_sqlserver_id	1 minute
mssql_tempdb_disk_size	Temporary Tablespace Size	Disk space occupied by the current temporary tablespace	≥ 0	MiB	1024	rds_cluster_sqlserver_id	1 minute
mssql_worker_threads_usage_rate	Usage of Worker Threads	Ratio of the total worker threads to the value of Max Worker Threads.	0–100	%	N/A	rds_cluster_sqlserver_id	1 minute
sys015_mem_paged_pool	Paged Pool	The paged pool occupied by the current OS	0–99999999	MiB	N/A	rds_cluster_sqlserver_id	120 minutes
sys018_mem_modified	Modified Memory	The modified memory occupied by the current OS	0–99999999	MiB	N/A	rds_cluster_sqlserver_id	5 minutes