The Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the AWS Cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.

A DB instance is an isolated database environment in the AWS Cloud with the following characteristics:

  • Can have multiple user-created databases.
  • Runs a DB engine. Amazon RDS currently supports the MySQL, MariaDB, PostgreSQL, Oracle, and Microsoft SQL Server DB engines.
  • Each DB engine has its own supported features, and each version of a DB engine may include specific features.
  • Has a set of parameters in a DB parameter group that controls the behavior of the databases that it manages.

You can do the following:

  • Access a DB instance using the same tools and applications used with a standalone database instance.
  • Create and change a DB instance by using the AWS Command Line Interface, the Amazon RDS API, or the AWS Management Console.

Use the AWS public cloud integration to discover and collect metrics against the AWS service.

Setup

To set up the AWS integration and discover the AWS service, navigate to AWS Integration Discovery Profile and select RDS.

Event support

CloudTrail event support

  • Supported (CreateDBCluster, DeleteDBCluster)
  • Configurable in OpsRamp AWS Integration Discovery Profile.

CloudWatch alarm support

  • Supported
  • Configurable in OpsRamp AWS Integration Discovery Profile.

Supported metrics

OpsRamp MetricAWS MetricMetric Display NameUnitDescriptionAggregation Type
cloud.instance.staten/aStatus/Staten/an/an/a
aws_rds_CPUUtilizationCPUUtilizationCPU utilizationPercentPercentage of allocated EC2 compute units that are currently in use on the instance. This metric identifies the processing power required to run an application on a selected instance.Average
aws_rds_BinLogDiskUsageBinLogDiskUsageBinLogDiskUsageBytesAmount of disk space occupied by binary logs on the master. Applies to MySQL read replicas.Sum
aws_rds_DatabaseConnectionsDatabaseConnectionsDatabaseConnectionsCountThe number of database connections in use.Average
aws_rds_DiskQueueDepthDiskQueueDepthDiskQueueDepthCountThe number of outstanding IOs (read/write requests) waiting to access the disk.Sum
aws_rds_FreeableMemoryFreeableMemoryFreeableMemoryFreeable MemoryAmount of available random access memory.Average
aws_rds_FreeStorageSpaceFreeStorageSpaceFreeStorageSpaceFree SpaceAmount of available storage space.Average
aws_rds_SwapUsageSwapUsageSwapUsageSwap UsageAmount of swap space used on the DB Instance.Sum
aws_rds_NetworkReceiveThroughputNetworkReceiveThroughputNetworkReceiveThroughputIncoming (receive) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication.Average
aws_rds_NetworkTransmitThroughputNetworkTransmitThroughputNetworkTransmitThroughputOutgoing (transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication.Average
aws_rds_ReadThroughputReadThroughputReadThroughputAverage number of bytes read from disk per second.Average
aws_rds_WriteThroughputWriteThroughputWriteThroughputAverage number of bytes written to disk per second.Average
aws_rds_ReadIOPSReadIOPSReadIOPSCount/SecThe average number of disk read operations per second.Average
aws_rds_WriteIOPSWriteIOPSWriteIOPSCount/SecThe average number of write operations per second.Average
aws_rds_ReadLatencyReadLatencyReadLatencySecondsThe average amount of time taken for disk read I/O operations.Average
aws_rds_WriteLatencyWriteLatencyWriteLatencySecondsThe average amount of time taken for disk write I/O operations.Average
aws_rds_ReplicaLagReplicaLagReplicaLagSecondsAmount of time a Read Replica DB Instance lags behind the source DB Instance. Applies to MySQL read replicas.Average
aws_rds_CPUCreditBalanceCPUCreditBalanceCPUCreditBalanceCount[T2 instances] Number of CPU credits available for the instance to burst beyond its base CPU utilization. Credits are stored in the credit balance after they are earned and removed from the credit balance after they expire. Credits expire 24 hours after they are earned. CPU credit metrics are available only at a 5-minute frequency.Average
aws_rds_CPUCreditUsageCPUCreditUsageCPUCreditUsageCount[T2 instances] Number of CPU credits available for the instance to burst beyond its base CPU utilization. Credits are stored in the credit balance after they are earned and removed from the credit balance after they expire. Credits expire 24 hours after they are earned. CPU credit metrics are available only at a 5-minute frequency.Average
aws_rds_BurstBalanceBurstBalanceBurstBalancePercentUsed with General Purpose SSD (gp2), Throughput Optimized HDD (st1), and Cold HDD (sc1) volumes only. Provides information about the Percentage of I/O credits (for gp2) or throughput credits (for st1 and sc1) remaining in the burst bucket. Data is reported to CloudWatch only when the volume is active. If the volume is not attached, no data is reported.Average
aws_rds_AuroraGlobalDBReplicatedWriteIOAuroraGlobalDBReplicatedWriteIOAuroraGlobalDBReplicatedWriteIOCountIndicates the number of write I/O operations replicated in the Aurora Global database.Sum
aws_rds_AuroraGlobalDBDataTransferBytes

AuroraGlobalDBDataTransferBytesAuroraGlobalDBDataTransferBytesCountIndicates the data transferred in bytes in the Aurora Global database.Sum
aws_rds_AuroraGlobalDBReplicationLag

AuroraGlobalDBReplicationLagAuroraGlobalDBReplicationLagMillisecondsIndicates the amount of lag replicated in the Aurora Global database.Sum
aws_rds_MaximumUsedTransactionIDsMaximumUsedTransactionIDsMaximumUsedTransactionIDsCountMaximum transaction ID used. Applies to PostgreSQL.Average
aws_rds_OldestReplicationSlotLagOldestReplicationSlotLagOldestReplicationSlotLagMegabytesThe size of the replica lagged the most in terms of WAL data received. Applies to PostgreSQL.Sum
aws_rds_ReplicationSlotDiskUsageReplicationSlotDiskUsageReplicationSlotDiskUsageMegabytesDisk space used by replication slot files. Applies to PostgreSQL.Sum
aws_rds_TransactionLogsDiskUsageTransactionLogsDiskUsageTransactionLogsDiskUsageMegabytesDisk space used by transaction logs applies to PostgreSQL.Sum
aws_rds_TransactionLogsGenerationTransactionLogsGenerationTransactionLogsGenerationMegabytesThe size of transaction logs generated per second applies to PostgreSQL.Average
aws_rds_ActiveTransactionsActiveTransactionsActive TransactionsCountThe average number of current transactions executing on a database instance per second.Average
aws_rds_BlockedTransactionsBlockedTransactionsBlocked TransactionsCountThe average number of blocked transactions on a database.Average
aws_rds_BufferCacheHitRatioBufferCacheHitRatioBuffer Cache Hit RatioPercentThe percentage of requests that are served by the buffer cache.Average
aws_rds_CommitThroughputCommitThroughputCommit ThroughputCount/SecondThe average number of commit operations per second.Average
aws_rds_CommitLatencyCommitLatencyCommit LatencyMillisecondsGets the cumulative commit latency in milliseconds for Aurora PostgreSQL databases.Average
aws_rds_DDLLatencyDDLLatencyDDL LatencyMillisecondsThe average duration of requests in milliseconds.Average
aws_rds_DeadlocksDeadlocksDeadlocksCountThe average count of deadlocks in the database.Average
aws_rds_DMLThroughputDMLThroughputDML ThroughputCount/SecondThe average number of inserts, updates, and deletes per second.Average
aws_rds_DMLLatencyDMLLatencyDML LatencyMillisecondsThe average count of DML latency in milliseconds.Average
aws_rds_LoginFailuresLoginFailuresLogin FailuresCountProvides failed login counts of a database.Average
aws_rds_ResultSetCacheHitRatioResultSetCacheHitRatioResult Set Cache Hit RatioPercentThe percentage of requests that are served by the Resultset cache.Average
aws_rds_ReplicaLagMaximumReplicaLagMaximumReplica Lag MaximumMillisecondsThe maximum amount of lag between the primary instance and any of the DB instances in the DB cluster.Average
aws_rds_AuroraReplicaLagMaximumAuroraReplicaLagMaximumAurora Replica Lag MaximumMillisecondsThe maximum amount of lag between the primary instance and any of the Aurora DB instances in the DB cluster.Maximum
aws_rds_AuroraReplicaLagMinimumAuroraReplicaLagMinimumAurora Replica Lag MinimumMillisecondsThe minimum amount of lag between the primary instance and any of the Aurora DB instances in the DB cluster.Minimum
aws_rds_SelectThroughputSelectThroughputSelect ThroughputCount/SecondThe average number of select queries per second.Average
aws_rds_SelectLatencySelectLatencySelect LatencyMillisecondsThe average amount of time for select operations.Average
aws_rds_VolumeReadIOPsVolumeReadIOPSVolume Read IOPSCountThe number of billed read I/O operations from a cluster volume.Sum
aws_rds_VolumeWriteIOPsVolumeWriteIOPsVolume Write IOPsCountThe number of billed write I/O operations from a cluster volume.Sum
aws_rds_QueriesQueriesQueriesCount/SecondThe average count of queries in a database.Average
aws_rds_AuroraBinlogReplicaLagAuroraBinlogReplicaLagAurora Binlog Replica LagSecondsThe amount of time a binary log replica DB cluster runs on Aurora MySQL-Compatible Edition lags.Sum
aws_rds_EngineUptimeEngineUptimeEngine UptimeSecondsThe amount of time that the instance has been running.Sum
aws_rds_InsertLatencyInsertLatencyInsert LatencyMillisecondsThe average duration of insert operations.Average
aws_rds_InsertThroughputInsertThroughputInsert ThroughputCount/SecondThe average number of insert operations per second.Average
aws_rds_UpdateLatencyUpdateLatencyUpdate LatencyMillisecondsThe average amount of time taken for update operations.Average
aws_rds_UpdateThroughputUpdateThroughputUpdate ThroughputCount/SecondThe average number of update operations per second.Average
aws_rds_DeleteLatencyDeleteLatencyDelete LatencyMillisecondsThe average duration of delete operations.Average
aws_rds_DeleteThroughputDeleteThroughputDelete ThroughputCount/SecondThe average number of delete operations per second.Average
aws_rds_NetworkThroughputNetworkThroughputNetwork ThroughputBytes/SecondThe network traffic on the DB instance.Average
aws_rds_BacktrackChangeRecordsCreationRateBacktrackChangeRecordsCreationRateBacktrack Change Records Creation RateCountShows the number of backtrack change records created for your DB cluster.Sum
aws_rds_BacktrackChangeRecordsStoredBacktrackChangeRecordsStoredBacktrack Change Records StoredCountThe actual number of backtrack change records used by your DB cluster.Sum
aws_rds_BacktrackWindowAlertBacktrackWindowAlertBacktrack Window AlertCountThe number of times the actual backtrack window is smaller than the target backtrack window for a given period.Sum
aws_rds_ServerlessDatabaseCapacityServerlessDatabaseCapacityServerlessDatabaseCapacityCountReports the number of ACUs represented by the current DB instance capacity.Sum
aws_rds_FailedSQLServerAgentJobsCountFailedSQLServerAgentJobsCountFailedSQLServerAgentJobsCountCountThe number of failed Microsoft SQL Server Agent jobs.Sum
aws_rds_DBLoadDBLoadDB LoadNoneThe number of active sessions for the DB engine. This shows the data for the average number of active sessions. In Performance Insights, this data is queried as db.load.avg.Average
aws_rds_DBLoadCPUDBLoadCPUDB Load CPUNoneThe number of active sessions where the wait event type is CPU. In Performance Insights, this data is queried as db.load.avg, filtered by the wait event type CPU.Average
aws_rds_DBLoadNonCPUDBLoadNonCPUDB Load Non CPUNoneThe number of active sessions where the wait event type is not CPU.Average

External reference

What is Amazon RDS?