Amazon Aurora monitoring
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
-
ActiveGate version 1.181+, as follows:
-
For Dynatrace SaaS deployments, you need an Environment ActiveGate or a Multi-environment ActiveGate.
-
For Dynatrace Managed deployments, you can use any kind of ActiveGate.
For role-based access (whether in a SaaS or Managed deployment), you need an Environment ActiveGate installed on an Amazon EC2 host.
-
-
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.
Enable monitoring
To enable monitoring for this service, you first need to integrate Dynatrace with Amazon Web Services:
Add the service to monitoring
In order to view the service metrics, you must add the service to monitoring in your Dynatrace environment.
Once AWS cloud services are added to monitoring, you might have to wait 15-20 minutes before the metric values are displayed.
All cloud services consume Davis data units (DDUs). The amount of DDU consumption per service instance depends on the number of monitored metrics and their dimensions (each metric dimension results in the ingestion of 1 data point; 1 data point consumes 0.001 DDUs).
Monitor resources based on tags
You can choose to monitor resources based on existing AWS tags, as Dynatrace automatically imports them from service instances. Nevertheless, the transition from AWS to Dynatrace tagging isn't supported for all AWS services. Expand the table below to see which cloud services are filtered by tagging.
To monitor resources based on tags
- In the Dynatrace menu, go to Settings > Cloud and virtualization > AWS and select Edit for the desired AWS instance.
- For Resources to be monitored, select Monitor resources selected by tags.
- Enter the Key and Value.
- Select Save.
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.
Once AWS cloud services are configured, you might have to wait 15-20 minutes before the metric values are displayed.
View service metrics
You can view the service metrics in your Dynatrace environment either on the custom device overview page or on your Dashboards page.
View metrics on the custom device overview page
To access the custom device overview page
- In the Dynatrace menu, go to Technologies and processes.
- Filter by service name and select the relevant custom device group.
- Once you select the custom device group, you're on the custom device group overview page.
- The custom device group overview page lists all instances (custom devices) belonging to the group. Select an instance to view the custom device overview page.
View metrics on your dashboard
You can also view metrics in the Dynatrace web UI on dashboards. There is no preset dashboard available for this service, but you can create your own dashboard.
To check the availability of preset dashboards for each AWS service, see the list below.
Available metrics
This service monitors Amazon RDS clusters. You can find the already monitored resources on the AWS overview page in theCloud services section. To monitor RDS instances instead, check the Amazon RDS and the RDS section on the AWS overview page.
| 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 |