Amazon Aurora

Dynatrace ingests metrics for multiple preselected namespaces, including Amazon Aurora. You can view metrics for each service instance, split metrics into multiple dimensions, and create custom charts that you can pin to your dashboards.

Prerequisites

To enable monitoring for this service, you need

  • An Environment or Cluster ActiveGate version 1.181+
  • Dynatrace version 1.182+
  • An updated AWS monitoring policy to include the additional AWS services.
    To update the AWS IAM policy, use the JSON below, containing the monitoring policy (permissions) for all supporting services.

If you don't want to add permissions to all services, and just select permissions for certain services, consult the table below. The table contains a set of permissions that are required for all services (All monitored Amazon services) and, for each supporting service, a list of optional permissions specific to that service.

Example of JSON policy for one single service.

In this example, from the complete list of permissions you need to select

  • "apigateway:GET" for Amazon API Gateway
  • "cloudwatch:GetMetricData", "cloudwatch:GetMetricStatistics", "cloudwatch:ListMetrics", "sts:GetCallerIdentity", "tag:GetResources", "tag:GetTagKeys", and "ec2:DescribeAvailabilityZones" for All monitored Amazon services.

Add the service to monitoring

In order to view the service metrics, you must add the service to monitoring in your Dynatrace environment.

Note: Once AWS supporting services are added to monitoring, you might have to wait 15-20 minutes before the metric values are displayed.

Configure service metrics

Once you add a service, Dynatrace starts automatically collecting a suite of metrics for this particular service. These are recommended metrics. Apart from the recommended metrics, most services have the possibility of enabling optional metrics. You can remove or edit any of the existing metrics or any of their dimensions, where there are multiple dimensions available. Metrics consisting of only one dimension can't be edited. They can only be removed or added.

Service-wide metrics are metrics for the whole service across all regions. Typically, these metrics include dimensions containing Region in their name. If selected, these metrics are displayed on a separate chart when viewing your AWS deployment in Dynatrace. Keep in mind that available dimensions differ among services.

To change a metric's statistics, you have to recreate that metric by choosing different statistics. You can choose among the following statistics: Sum, Minimum, Maximum, Average, and Sample count. The Average + Minimum + Maximum statistics enable you to collect all three statistics as one metric instead of one statistic for three metrics separately. This can reduce your expenses for retrieving metrics from your AWS deployment.

To be able to save a newly added metric, you need to select at least one statistic and one dimension.

Note: Once AWS supporting services are configured, you might have to wait 15-20 minutes before the metric values are displayed.

View service metrics

Once you add the service to monitoring, you can view the service metrics in your Dynatrace environment either on your dashboard page or on the custom device overview page.

Available metrics

Name Description Unit Statistics Dimensions Recommended
ActiveTransactions The average number of current transactions executing on an Aurora database instance per second Count/Second Average Region; Region, EngineName; Region, DatabaseClass
ActiveTransactions Count/Second Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
ActiveTransactions Count/Second Maximum Region; Region, EngineName; Region, DatabaseClass
ActiveTransactions Count/Second Maximum DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
AuroraBinlogReplicaLag The amount of time a replica DB cluster running on Aurora with MySQL compatibility lags behind the source DB cluster Seconds Multi Region; Region, EngineName; Region, DatabaseClass
AuroraBinlogReplicaLag Seconds Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
AuroraReplicaLag For an Aurora replica, the amount of lag when replicating updates from the primary instance Milliseconds Average Region; Region, EngineName; Region, DatabaseClass
AuroraReplicaLag Milliseconds Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
AuroraReplicaLagMaximum The maximum amount of lag between the primary instance and each Aurora DB instance in the DB cluster Milliseconds Average Region; Region, EngineName; Region, DatabaseClass
AuroraReplicaLagMaximum Milliseconds Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
AuroraReplicaLagMinimum Milliseconds Average Region; Region, EngineName; Region, DatabaseClass
AuroraReplicaLagMinimum Milliseconds Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
BacktrackChangeRecordsCreationRate The number of backtrack change records created over 5 minutes for your DB cluster Count Sum Region; Region, EngineName; Region, DatabaseClass
BacktrackChangeRecordsCreationRate Count Sum DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
BacktrackChangeRecordsStored The number of backtrack change records used by your DB cluster Count Sum Region; Region, EngineName; Region, DatabaseClass
BacktrackChangeRecordsStored Count Sum DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
BacktrackWindowActual The difference between the target backtrack window and the actual backtrack window Count Sum Region; Region, EngineName; Region, DatabaseClass
BacktrackWindowActual Count Sum DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
BacktrackWindowAlert The number of times that the actual backtrack window is smaller than the target backtrack window for a given period of time Count Sum Region; Region, EngineName; Region, DatabaseClass
BacktrackWindowAlert Count Sum DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
BinLogDiskUsage The amount of disk space occupied by binary logs on the primary instance Bytes Average Region; Region, EngineName; Region, DatabaseClass
BinLogDiskUsage Bytes Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
BlockedTransactions The average number of transactions in the database that are blocked per second Count/Second Average Region; Region, EngineName; Region, DatabaseClass
BlockedTransactions Count/Second Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
BlockedTransactions Count/Second Maximum Region; Region, EngineName; Region, DatabaseClass
BlockedTransactions Count/Second Maximum DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
BufferCacheHitRatio The percentage of requests that are served by the buffer cache Percent Average Region; Region, EngineName; Region, DatabaseClass
BufferCacheHitRatio Percent Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
CPUCreditBalance The number of CPU credits that an instance has accumulated, reported at 5-minute intervals. This metric applies only to db.t2.small and db.t2.medium instances. You can use this metric to determine how long an Aurora MySQL DB instance can burst beyond its baseline performance level at a given rate. Count Average Region; Region, EngineName; Region, DatabaseClass
CPUCreditBalance Count Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
CPUCreditUsage The number of CPU credits consumed during the specified period, reported at 5-minute intervals. This metric applies only to db.t2.small and db.t2.medium instances. This metric measures the amount of time during which physical CPUs have been used for processing instructions by virtual CPUs allocated to the Aurora MySQL DB instance. Count Average Region; Region, EngineName; Region, DatabaseClass
CPUCreditUsage Count Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
CPUUtilization The percentage of CPU used by an Aurora DB instance Percent Average Region; Region, EngineName; Region, DatabaseClass
CPUUtilization Percent Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
CPUUtilization Percent Maximum Region; Region, EngineName; Region, DatabaseClass
CPUUtilization Percent Maximum DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
CommitLatency The latency for commit operations Milliseconds Multi Region; Region, EngineName; Region, DatabaseClass
CommitLatency Milliseconds Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
CommitThroughput The average number of commit operations per second Count/Second Multi Region; Region, EngineName; Region, DatabaseClass
CommitThroughput Count/Second Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
DDLLatency The latency for data definition language (DDL) requests such as example, create, alter, and drop requests Milliseconds Multi Region; Region, EngineName; Region, DatabaseClass
DDLLatency Milliseconds Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
DDLThroughput The average number of DDL requests per second Count/Second Multi Region; Region, EngineName; Region, DatabaseClass
DDLThroughput Count/Second Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
DMLLatency The latency for inserts, updates, and deletes Milliseconds Multi Region; Region, EngineName; Region, DatabaseClass
DMLLatency Milliseconds Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
DMLThroughput The average number of inserts, updates, and deletes per second Count/Second Multi Region; Region, EngineName; Region, DatabaseClass
DMLThroughput Count/Second Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
DatabaseConnections The number of connections to an Aurora DB instance Count Average Region; Region, EngineName; Region, DatabaseClass
DatabaseConnections Count Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
DatabaseConnections Count Maximum Region; Region, EngineName; Region, DatabaseClass
DatabaseConnections Count Maximum DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
Deadlocks The average number of deadlocks in the database per second Count/Second Average Region; Region, EngineName; Region, DatabaseClass
Deadlocks Count/Second Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
Deadlocks Count/Second Maximum Region; Region, EngineName; Region, DatabaseClass
Deadlocks Count/Second Maximum DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
DeleteLatency The latency for delete queries Milliseconds Multi Region; Region, EngineName; Region, DatabaseClass
DeleteLatency Milliseconds Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
DeleteThroughput The average number of delete queries per second Count/Second Multi Region; Region, EngineName; Region, DatabaseClass
DeleteThroughput Count/Second Multi DBClusterIdentifier, Role
DeleteThroughput Count/Second Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass ✔️
DiskQueueDepth The number of outstanding read/write requests waiting to access the disk Count Multi Region; Region, EngineName; Region, DatabaseClass
DiskQueueDepth Count Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
EngineUptime The amount of time that the instance has been running Seconds Average Region; Region, EngineName; Region, DatabaseClass
EngineUptime Seconds Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
FreeLocalStorage The amount of local storage available for each DB instance. Bytes Average Region; Region, EngineName; Region, DatabaseClass
FreeLocalStorage Bytes Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
FreeableMemory The amount of available random access memory Bytes Average Region; Region, EngineName; Region, DatabaseClass
FreeableMemory Bytes Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
InsertLatency The latency for insert queries Milliseconds Multi Region; Region, EngineName; Region, DatabaseClass
InsertLatency Milliseconds Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
InsertThroughput The average number of insert queries per second Count/Second Multi Region; Region, EngineName; Region, DatabaseClass
InsertThroughput Count/Second Multi DBClusterIdentifier, Role
LoginFailures The average number of failed login attempts per second Count/Second Average Region; Region, EngineName; Region, DatabaseClass
LoginFailures Count/Second Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
UpdateThroughput The average number of update queries per second Count/Second Multi DBClusterIdentifier ✔️
LoginFailures The average number of failed login attempts per second Count/Second Maximum Region; Region, EngineName; Region, DatabaseClass
LoginFailures Count/Second Maximum DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
MaximumUsedTransactionIDs The age of the oldest unvacuumed transaction ID in transactions. If this value reaches 2,146,483,648 (2^31 - 1,000,000), the database is forced into read-only mode, to avoid transaction ID wraparound. Count Average Region; Region, EngineName; Region, DatabaseClass
MaximumUsedTransactionIDs Count Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
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. Bytes/Second Multi Region; Region, EngineName; Region, DatabaseClass
NetworkReceiveThroughput Bytes/Second Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
NetworkThroughput The amount of network throughput both received from and transmitted to clients by each instance in the Aurora MySQL DB cluster. This throughput doesn't include network traffic between instances in the DB cluster and the cluster volume. Bytes/Second Multi Region; Region, EngineName; Region, DatabaseClass
NetworkThroughput Bytes/Second Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
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. Bytes/Second Multi Region; Region, EngineName; Region, DatabaseClass
NetworkTransmitThroughput Bytes/Second Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
Queries The average number of queries executed per second Count/Second Multi Region; Region, EngineName; Region, DatabaseClass
Queries Count/Second Multi DBClusterIdentifier, Role
InsertThroughput The average number of insert queries per second Count/Second Multi DBClusterIdentifier ✔️
RDSToAuroraPostgreSQLReplicaLag The lag when replicating updates from the primary RDS PostgreSQL instance to other nodes in the cluster Seconds Multi Region; Region, EngineName; Region, DatabaseClass
RDSToAuroraPostgreSQLReplicaLag Seconds Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
ReadIOPS The average number of disk I/O operations per second Count/Second Multi Region; Region, EngineName; Region, DatabaseClass
ReadIOPS Count/Second Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
ReadLatency The average amount of time taken per disk I/O operation Seconds Multi Region; Region, EngineName; Region, DatabaseClass
ReadLatency Seconds Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
ReadThroughput The average number of bytes read from disk per second Bytes/Second Multi Region; Region, EngineName; Region, DatabaseClass
ReadThroughput Bytes/Second Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
ResultSetCacheHitRatio The percentage of requests that are served by the resultset cache Percent Average Region; Region, EngineName; Region, DatabaseClass
ResultSetCacheHitRatio Percent Average DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
ResultSetCacheHitRatio Percent Maximum Region; Region, EngineName; Region, DatabaseClass
ResultSetCacheHitRatio Percent Maximum DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
SelectLatency The latency for select queries Milliseconds Multi Region; Region, EngineName; Region, DatabaseClass
SelectLatency Milliseconds Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
SelectThroughput The average number of select queries per second Count/Second Multi Region; Region, EngineName; Region, DatabaseClass
SelectThroughput Count/Second Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
SwapUsage The amount of swap space used on the Aurora PostgreSQL DB instance Bytes Multi Region; Region, EngineName; Region, DatabaseClass
SwapUsage Bytes Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
TransactionLogsDiskUsage The amount of disk space consumed by transaction logs on the Aurora PostgreSQL DB instance. This metric is only generated when Aurora PostgreSQL is using logical replication or AWS Database Migration Service. By default, Aurora PostgreSQL uses log records, not transaction logs. When transaction logs aren't in use, the value for this metric is -1. Bytes Multi Region; Region, EngineName; Region, DatabaseClass
TransactionLogsDiskUsage Bytes Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
UpdateLatency The latency for update queries Milliseconds Multi Region; Region, EngineName; Region, DatabaseClass
UpdateLatency Milliseconds Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
UpdateThroughput The average number of update queries per second Count/Second Multi Region; Region, EngineName; Region, DatabaseClass
UpdateThroughput Count/Second Multi DBClusterIdentifier, Role
Queries The average number of queries executed per second Count/Second Multi DBClusterIdentifier ✔️
VolumeBytesUsed The amount of storage used by your Aurora DB instance. This value affects the cost of the Aurora DB cluster. Bytes Multi Region; Region, EngineName; Region, DatabaseClass
VolumeBytesUsed Bytes Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
VolumeReadIOPs The number of billed read I/O operations from a cluster volume within a 5-minute interval Count/Second Multi Region; Region, EngineName; Region, DatabaseClass
VolumeReadIOPs Count/Second Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
VolumeWriteIOPs The number of write disk I/O operations to the cluster volume, reported at 5-minute intervals Count/Second Multi Region; Region, EngineName; Region, DatabaseClass
VolumeWriteIOPs Count/Second Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
WriteIOPS The average number of disk I/O operations per second Count/Second Multi Region; Region, EngineName; Region, DatabaseClass
WriteIOPS Count/Second Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
WriteLatency The average amount of time taken per disk I/O operation Seconds Multi Region; Region, EngineName; Region, DatabaseClass
WriteLatency Seconds Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass
WriteThroughput The average number of bytes written to disk Bytes/Second Multi Region; Region, EngineName; Region, DatabaseClass
WriteThroughput Bytes/Second Multi DBClusterIdentifier; DBClusterIdentifier, Role; Region, DatabaseClass