Configuring Displayed Metrics

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

• Table 1 lists the performance metrics of RDS for SQL Server DB instances.

  Table 1 Performance 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
  mssql_worker_threads_usage_rate	Usage of Worker Threads	Ratio of the total worker threads to the value of Max Worker Threads.	0~100%	RDS for SQL Server instance	1 minute

Dimension