Download PDF
Download page Amazon Relational Database Service.
Amazon Relational Database Service
Amazon Relational Database Service (RDS) is a database service that simplifies the setup, operation, and scaling of relational databases in the AWS cloud.
You must configure cloud connections to monitor this entity. See Set up Cisco AppDynamics Cloud Collectors to Monitor AWS. For detailed visibility, such as query profiling and streamlined troubleshooting, install Database Monitoring.
Cisco Cloud Observability displays AWS entities on the Observe page. Metrics are displayed for specific entity instances in the list and detail views.
This document contains references to third-party documentation. Splunk AppDynamics does not own any rights and assumes no responsibility for the accuracy or completeness of such third-party documentation.
Detail View
To display the detail view for an Amazon RDS instance:
- Navigate to the Observe page.
- Under Database & Storage, use one of the following flows based on the database entity type that you want to view:
- Click a SQL Database Clusters group. The SQL Database Clusters list view now displays.
- Click a SQL Database Instances group. The SQL Database Instances list view now displays. Click AWS to display only AWS database instances.
- Click a SQL Database Instances group. The SQL Database Instances list view now displays. Click AWS to display only AWS database instances. In the left-hand navigation panel, click Databases.
- From the list view, click a database Name to display the detail view.
The detail view displays metrics, key performance indicators, and properties (attributes) related to the database you selected.
Metrics and Key Performance Indicators
Cisco Cloud Observability displays the following metrics and key performance indicators (KPIs) for Amazon databases. See Amazon Aurora metrics and Monitoring Amazon RDS Metrics with Amazon CloudWatch.
Database Clusters
Display Name | Source Metric | Description |
---|---|---|
Database Connections (Count) | DatabaseConnections
| The number of client network connections to the database instance. |
CPU Utilization (%) | CPUUtilization | The percentage of CPU used by an Aurora DB. |
Freeable Memory (Bytes) | FreeableMemory
| The amount of available random access memory. |
Network Transmit Throughput (Bytes/Sec) | NetworkTransmitThroughput
| The amount of network throughput sent to clients by each instance in the Aurora DB cluster. This throughput doesn't include network traffic between instances in the DB cluster and the cluster volume. |
Network Receive Throughput (Bytes/Sec) | NetworkReceiveThroughput
| The amount of network throughput received from clients by each instance in the Aurora MySQL DB cluster. This throughput doesn't include network traffic between instances in the Aurora DB cluster and the cluster volume. |
Bin Log Disk Usage (Bytes) | BinLogDiskUsage | The amount of disk space occupied by binary logs on the primary instance. Applies to MySQL read replicas. |
Active Transactions (Count/Sec) | ActiveTransactions | (Aurora MySQL) The average number of current transactions executing on an Aurora database instance per second. By default, Aurora doesn't enable this metric. To measure this value, set innodb_monitor_enable='all' in the DB parameter group for a specific DB instance. |
Blocked Transactions (Count/Sec) | BlockedTransactions | (Aurora MySQL) The average number of transactions in the database that is blocked per second. |
Buffer Cache Hit Ratio (%) | BufferCacheHitRatio | The percentage of requests that are served by the buffer cache. |
Free Local Storage (Bytes) | FreeLocalStorage | The amount of local storage available. |
Network Throughput (Bytes/Sec) | NetworkThroughput | The amount of network throughput both received from and transmitted to clients by each instance. |
Insert Latency (ms) | InsertLatency | The average duration of insert operations. |
Insert Throughput (Ops/Sec) | InsertThroughput | The average number of insert operations per second. |
Select Latency (ms) | SelectLatency | The average duration of select operations. |
Select Throughput (Ops/Sec) | SelectThroughput | The average number of select operations per second. |
Update Latency (ms) | UpdateLatency | The average duration of update operations. |
Update Throughput (Ops/Sec) | UpdateThroughput | The average number of update operations per second. |
Commit Latency (ms) | CommitLatency | The average duration of commit operations. |
Commit Throughput (Ops/Sec) | CommitThroughput | The average number of commit operations per second. |
DDL Latency (ms) | DDLLatency | The average duration of DDL operations. |
DDL Throughput (Ops/Sec) | DDLThroughput | The average number of DDL operations per second. |
DML Latency (ms) | DMLLatency | The average duration of DML operations. |
DML Throughput (Ops/Sec) | DMLThroughput | The average number of DML operations per second. |
Delete Latency (ms) | DeleteLatency | The average duration of delete operations. |
Delete Throughput (Ops/Sec) | DeleteThroughput | The average number of delete operations per second. |
Read/Write Latency (Sec) |
|
|
Deadlocks (Count/Sec) | Deadlocks | The average number of deadlocks in the database per second. |
Volume Bytes Used | VolumeBytesUsed | The amount of storage used by your Aurora DB instance. This value affects the cost of the Aurora DB cluster. |
Volume IOPS (Count/Sec) |
| The number of billed read and write disk I/O operations to the cluster volume, reported at 5-minute intervals. |
Database Instances
Display Name | Source Metric | Description |
---|---|---|
CPU Utilization (%) | CPUUtilization | The percentage of CPU used by an Aurora DB instance. |
Network Transmit Throughput (Bytes/Sec) | NetworkTransmitThroughput
| The amount of network throughput sent to clients by each instance in the Aurora DB cluster. This throughput doesn't include network traffic between instances in the DB cluster and the cluster volume. |
Network Receive Throughput (Bytes/Sec) | NetworkReceiveThroughput
| The amount of network throughput received from clients by each instance in the Aurora MySQL DB cluster. This throughput doesn't include network traffic between instances in the Aurora DB cluster and the cluster volume. |
Bin Log Disk Usage (Bytes) | BinLogDiskUsage | The amount of disk space occupied by binary logs on the primary instance. Applies to MySQL read replicas. |
Free Local Storage (Bytes) | FreeLocalStorage | The amount of local storage available. |
Active Transactions (Count/Sec) | ActiveTransactions | The average number of current transactions executing on an Aurora database instance per second. By default, Aurora doesn't enable this metric. To begin measuring this value, set innodb_monitor_enable='all' in the DB parameter group for a specific DB instance. |
Blocked Transactions (Count/Sec) | BlockedTransactions | The average number of transactions in the Aurora database that are blocked per second. |
Buffer Cache Hit Ratio (%) | BufferCacheHitRatio | The percentage of requests that are served by the buffer cache. |
Commit Latency (ms) | CommitLatency | The average duration of commit operations. |
Commit Throughput (Count/Sec) | CommitThroughput | The average number of commit operations per second. |
Delete Latency (ms) | DeleteLatency | The average duration of delete operations. |
Delete Throughput (Count/Sec) | DeleteThroughput | The average number of delete operations per second. |
Insert Latency (ms) | InsertLatency | The average duration of insert operations. |
Insert Throughput (Count/Sec) | InsertThroughput | The average number of insert operations per second. |
Select Latency (ms) | SelectLatency | The average duration of select operations. |
Select Throughput (Count/Sec) | SelectThroughput | The average number of select operations per second. |
Update Latency (ms) | UpdateLatency | The average duration of update operations. |
Update Throughput (Count/Sec) | UpdateThroughput | The average number of update operations per second. |
DDL Latency (ms) | DDLLatency | The average duration of DDL operations. |
DDL Throughput (Count/Sec) | DDLThroughput | The average number of DDL operations per second. |
DML Latency (ms) | DMLLatency | The average duration of DML operations. |
DML Throughput (Count/Sec) | DMLThroughput | The average number of DML operations per second. |
Deadlocks (Count/Sec) | Deadlocks | The average number of deadlocks in the database per second. |
Network Throughput (Bytes/Sec) | NetworkThroughput | The amount of network throughput both received from and transmitted to clients by each instance. |
Read/Write IOPS (Count/Sec) |
|
|
Read/Write Latency (Sec) |
|
|
Throughput (Bytes/Sec) |
|
|
Display Name | Source Metric | Description |
---|---|---|
CPU Utilization (%) | CPUUtilization | The percentage of CPU utilization. |
Freeable Memory (Bytes) | FreeableMemory
| The amount of available random access memory. |
Network Traffic (Bytes/Sec) |
|
|
Database Connections (Count) | DatabaseConnections
| The number of client network connections to the database instance. |
Bin Log Disk Usage (Bytes) | BinLogDiskUsage | The amount of disk space occupied by binary logs. If automatic backups are enabled for MySQL and MariaDB instances, including read replicas, binary logs are created. |
CPU Credits (vCPU-minutes) |
|
|
Disk Queue Depth (Count) | DiskQueueDepth | The number of outstanding read/write requests waiting to access the disk. |
Free Storage Spacce (Bytes) | FreeStorageSpace | The amount of available storage space. |
Read/Write IOPS (Count/Sec) |
|
|
Read/Write Latency (Sec) |
|
|
Throughput (Bytes/Sec) |
|
|
Swap Usage (Bytes) | SwapUsage | The amount of swap space used on the DB instance. |
LVM IOPs (Count/Sec) |
|
|
DB Load (Count) | DBLoad | The number of active sessions for the DB engine. Performance Insights must be enabled. |
DB Load CPU (Count) | DBLoadCPU | The number of active sessions where the wait event type is CPU. Performance Insights must be enabled. |
DB Load Non CPU (Count) | DBLoadNonCPU | The number of active sessions where the wait event type is not CPU. Performance Insights must be enabled. |
Replica Lag (Sec) | ReplicaLag | For read replica configurations, the amount of time a read replica DB instance lags behind the source DB instance. For Multi-AZ deployments, it measures the difference in time between the latest transaction on the writer DB instance and the latest applied transaction on a reader DB instance. This metric applies to MariaDB, Microsoft SQL Server, Oracle, MySQL, and PostgreSQL read replicas. |
Display Name | Source Metric | Description |
---|---|---|
CPU Utilization (%) | CPUUtilization | The percentage of CPU utilization. |
Freeable Memory (Bytes) | FreeableMemory
| The amount of available random access memory. |
Network Traffic (Bytes/Sec) |
|
|
Database Connections (Count) | DatabaseConnections
| The number of client network connections to the database instance. |
CPU Credits (vCPU-minutes) |
|
|
Disk Queue Depth (Count) | DiskQueueDepth | The number of outstanding read/write requests waiting to access the disk. |
Free Storage Space (Bytes) | FreeStorageSpace | The amount of available storage space. |
Read/Write IOPS (Count/Sec) |
|
|
Read/Write Latency (Sec) |
|
|
Throughput (Bytes/Sec) |
|
|
Swap Usage (Bytes) | SwapUsage | The amount of swap space used on the DB instance. |
Read/Write IOPS (Count/Sec) |
|
|
Read/Write Latency (Sec) |
|
|
Throughput (Bytes/Sec) |
|
|
Transaction Logs Disk Usage (Bytes) | TransactionLogsDiskUsage | The amount of disk space occupied by transaction logs. |
Transaction Logs Generation (Bytes/Sec) | TransactionLogsGeneration | The size of transaction logs generated per second. |
DB Load (Count) | DBLoad | The number of active sessions for the DB engine. Performance Insights must be enabled. |
DB Load CPU (Count) | DBLoadCPU | The number of active sessions where the wait event type is CPU. Performance Insights must be enabled. |
DB Load Non CPU (Count) | DBLoadNonCPU | The number of active sessions where the wait event type is not CPU. Performance Insights must be enabled. |
Replica Lag (Sec) | ReplicaLag | For read replica configurations, the amount of time a read replica DB instance lags behind the source DB instance. For Multi-AZ deployments, it measures the difference in time between the latest transaction on the writer DB instance and the latest applied transaction on a reader DB instance. This metric applies to MariaDB, Microsoft SQL Server, Oracle, MySQL, and PostgreSQL read replicas. |
Bin Log Disk Usage (Bytes) | BinLogDiskUsage | The amount of disk space occupied by binary logs. |
Display Name | Source Metric | Description |
CPU Utilization (%) | CPUUtilization | The percentage of CPU utilization. |
Freeable Memory (Bytes) | FreeableMemory
| The amount of available random access memory. |
Network Traffic (Bytes/Sec) |
|
|
Database Connections (Count) | DatabaseConnections
| The number of client network connections to the database instance. |
CPU Credits (vCPU-minutes) |
|
|
Disk Queue Depth (Count) | DiskQueueDepth | The number of outstanding read/write requests waiting to access the disk. |
Free Storage Space (Bytes) | FreeStorageSpace | The amount of available storage space. |
Read/Write IOPS (Count/Sec) |
|
|
Read/Write Latency (Sec) |
|
|
Throughput (Bytes/Sec) |
|
|
Swap Usage (Bytes) | SwapUsage | The amount of swap space used on the DB instance. |
Read/Write IOPS (Count/Sec) |
|
|
Read/Write Latency (Sec) |
|
|
Throughput (Bytes/Sec) |
|
|
DB Load (Count) | DBLoad | The number of active sessions for the DB engine. Performance Insights must be enabled. |
DB Load CPU (Count) | DBLoadCPU | The number of active sessions where the wait event type is CPU. Performance Insights must be enabled. |
DB Load Non CPU (Count) | DBLoadNonCPU | The number of active sessions where the wait event type is not CPU. Performance Insights must be enabled. |
Replica Lag (Sec) | ReplicaLag | For read replica configurations, the amount of time a read replica DB instance lags behind the source DB instance. For Multi-AZ deployments, it measures the difference in time between the latest transaction on the writer DB instance and the latest applied transaction on a reader DB instance. This metric applies to MariaDB, Microsoft SQL Server, Oracle, MySQL, and PostgreSQL read replicas. |
Bin Log Disk Usage (Bytes) | BinLogDiskUsage | The amount of disk space occupied by binary logs on the primary instance. Applies to MySQL read replicas. |
Display Name | Source Metric | Description |
---|---|---|
CPU Utilization (%) | CPUUtilization | The percentage of CPU utilization. |
Freeable Memory (Bytes) | FreeableMemory
| The amount of available random access memory. |
Network Traffic (Bytes/Sec) |
|
|
Database Connections (Count) | DatabaseConnections
| The number of client network connections to the database instance. |
Bin Log Disk Usage (Bytes) | BinLogDiskUsage | The amount of disk space occupied by binary logs. If automatic backups are enabled for MySQL and MariaDB instances, including read replicas, binary logs are created. |
CPU Credits (vCPU-minutes) |
|
|
Disk Queue Depth (Count) | DiskQueueDepth | The number of outstanding read/write requests waiting to access the disk. |
Free Storage Space (Bytes) | FreeStorageSpace | The amount of available storage space. |
Read/Write IOPS (Count/Sec) |
|
|
Read/Write Latency (Sec) |
|
|
Throughput (Bytes/Sec) |
|
|
Swag Usage (Bytes) | SwapUsage | The amount of swap space used on the DB instance. |
LVM IOPs (Count/Sec) |
|
|
DB Load (Count) | DBLoad | The number of active sessions for the DB engine. Performance Insights must be enabled. |
DB Load CPU (Count) | DBLoadCPU | The number of active sessions where the wait event type is CPU. Performance Insights must be enabled. |
DB Load Non CPU (Count) | DBLoadNonCPU | The number of active sessions where the wait event type is not CPU. Performance Insights must be enabled. |
Replica Lag (Sec) | ReplicaLag | For read replica configurations, the amount of time a read replica DB instance lags behind the source DB instance. For Multi-AZ deployments, it measures the difference in time between the latest transaction on the writer DB instance and the latest applied transaction on a reader DB instance. This metric applies to MariaDB, Microsoft SQL Server, Oracle, MySQL, and PostgreSQL read replicas. |
Display Name | Source Metric | Description |
---|---|---|
CPU Utilization (%) | CPUUtilization | The percentage of CPU utilization. |
Database Connections (Count) | DatabaseConnections
| The number of client network connections to the database instance. |
Disk Queue Depth (Count) | DiskQueueDepth | The number of outstanding read/write requests waiting to access the disk. |
Freeable Memory (Bytes) | FreeableMemory
| The amount of available random access memory. |
Swap Usage (Bytes) | SwapUsage | The amount of swap space used on the DB instance. |
Free Storage Space (Bytes) | FreeStorageSpace | The amount of available storage space. |
CPU Credits (vCPU-minutes) |
|
|
Network Traffic (Bytes/Sec) |
|
|
Read/Write IOPS (Count/Sec) |
|
|
Read/Write Latency (Sec) |
|
|
Throughput (Bytes/Sec) |
|
|
DB Load (Count) | DBLoad | The number of active sessions for the DB engine. Performance Insights must be enabled. |
DB Load CPU (Count) | DBLoadCPU | The number of active sessions where the wait event type is CPU. Performance Insights must be enabled. |
DB Load Non CPU (Count) | DBLoadNonCPU | The number of active sessions where the wait event type is not CPU. Performance Insights must be enabled. |
Bin Log Disk Usage (Bytes) | BinLogDiskUsage | The amount of disk space occupied by binary logs. If automatic backups are enabled for MySQL and MariaDB instances, including read replicas, binary logs are created. |
Replica Lag (Sec) | ReplicaLag | For read replica configurations, the amount of time a read replica DB instance lags behind the source DB instance. For Multi-AZ deployments, it measures the difference in time between the latest transaction on the writer DB instance and the latest applied transaction on a reader DB instance. This metric applies to MariaDB, Microsoft SQL Server, Oracle, MySQL, and PostgreSQL read replicas. |
Properties (Attributes)
Cisco Cloud Observability displays the following properties for Amazon databases. See Data Types.
Database Clusters
Display Name | Property Name | Description |
Cloud Provider | cloud.provider | The name of the cloud provider of the database. |
Account ID | cloud.account.id | The cloud account ID where the resource is assigned. |
Location | cloud.region | The geographical region where the resource is running. |
Zones | cloud.availability_zone | The logical zone list for the database. |
Database Name | DatabaseName | Contains the name of the initial database of this DB cluster that was provided at create time, if one was specified when the DB cluster was created. This same name is returned for the life of the DB cluster. |
DB Cluster Identifier | DBClusterIdentifier | Contains a user-supplied DB cluster identifier. This identifier is the unique key that identifies a DB cluster. |
DB ClusterResourceId | DbClusterResourceId | The AWS Region-unique is an immutable identifier for the DB cluster. This identifier is found in AWS CloudTrail log entries whenever the KMS key for the DB cluster is accessed. |
Type | Engine | The name of the database engine to be used for this DB cluster. |
Engine Version | EngineVersion | Indicates the database engine version. |
Status | Status | Specifies the current state of this DB cluster. |
Backup Retention Period | BackupRetentionPeriod | Specifies the number of days for which automatic DB snapshots are retained. |
Endpoint | Endpoint | Specifies the connection endpoint for the primary instance of the DB cluster. |
Port | Port | Specifies the port where the database engine is listening. |
Secondary Availability Zone |
| Specifies the name of the secondary Availability Zone for a DB instance with multi-AZ support. |
Class |
| Contains the name of the compute and memory capacity class of the DB instance. |
Storage Type |
| Specifies the storage type associated with DB instance. |
Database Instances
Display Name | Property Name | Description |
Cloud Provider | cloud.provider | The name of the cloud provider of the database. |
Account ID | cloud.account.id | The cloud account ID where the resource is assigned. |
Location | cloud.region | The geographical region where the resource is running. |
Zones | cloud.availability_zone | The logical zone list for the database. |
Database Name | DatabaseName | Contains the name of the initial database of this DB cluster that was provided at create time, if one was specified when the DB cluster was created. This same name is returned for the life of the DB cluster. |
DB Cluster Identifier | DBClusterIdentifier | Contains a user-supplied DB cluster identifier. This identifier is the unique key that identifies a DB cluster. |
Type | Engine | The name of the database engine to be used for this DB cluster. |
Engine Version | EngineVersion | Indicates the database engine version. |
Engine | Engine | The name of the database engine to be used for this DB cluster. |
Status | Status | Specifies the current state of this DB cluster. |
Endpoint | Endpoint | The endpoint that you can use to connect to the DB proxy. You include the endpoint value in the connection string for a database client application. |
Max Allocated Storage | MaxAllocatedStorage | The upper limit in gibibytes (GiB) to which Amazon RDS can automatically scale the storage of the DB instance. |
Storage Type | StorageType | The storage type associated with the DB cluster. This setting is only for non-Aurora Multi-AZ DB clusters. |
Endpoint Address | Address | Specifies the DNS address of the DB instance. |
Port | Port | Specifies the port where the database engine is listening. |
DB Security Groups | DBSecurityGroups | Contains the details for an Amazon RDS DB security group. |
DB Subnet Group Name | DBSubnetGroupName | The name of the DB subnet group. |
DB SubnetGroup Subnet Status | DBSubnetGroup_SubnetStatus | Provides the status of the DB subnet group. |
DB Instance Port | DbInstancePort | Specifies the port that the DB instance listens on. If the DB instance is part of a DB cluster, this can be a different port than the DB cluster port. |
Allocated Storage | AllocatedStorage | The total allocated storage per account, in GiB. The used value is the total allocated storage in the account, in GiB. |
I/O Operations Per Second | Provisioned IOPS | The provisioned IOPS value for the database. |
Secondary Availability Zone | SecondaryAvailabilityZone | Specifies the name of the secondary Availability Zone for a DB instance with multi-AZ support. |
RDS Non-Aurora includes MySQL, PostgreSQL, Oracle, and MariaDB.
Display Name | Property Name | Description |
Cloud Provider | cloud.provider | The name of the cloud provider of the database. |
Account ID | cloud.account.id | The cloud account ID where the resource is assigned. |
Location | cloud.region | The geographical region where the resource is running. |
Zones | cloud.availability_zone | The logical zone list for the database. |
Database Name | Friendly Name | Contains a user-supplied database identifier. |
DB identifier | DBInstanceIdentifier | This identifier is the unique key that identifies a DB instance. |
Info | DBInstanceStatus | Specifies the current state of this database. |
Type | Engine | The name of the database engine to be used for this DB instance. |
Engine Version | EngineVersion | Indicates the database engine version. |
Class | DBInstanceClass | Contains the name of the compute and memory capacity class of the DB instance. |
Endpoint | Address | Specifies the DNS address of the DB instance. |
Port | Port | Specifies the port where the database engine is listening. |
VpcId | VpcId | Provides the VpcId of the DB security group. |
Tags | Tag | Metadata assigned to an Amazon RDS resource consisting of a key-value pair. |
I/O Operations Per Second | Provisioned IOPS | The provisioned IOPS value for the database. |
Retention and Purge Time-To-Live (TTL)
For all cloud and infrastructure entities, the retention TTL is 180 minutes (3 hours) and the purge TTL is 525,600 minutes (365 days).
Amazon Web Services, the AWS logo, AWS, and any other AWS Marks used in these materials are trademarks of Amazon.com, Inc. or its affiliates in the United States and/or other countries.