Server & Application Monitor

Amazon RDS

AWS RDS full.apm-template

Overview

This template shows metrics for Amazon RDS databases.

Included Component Monitors

CPU Utilization
Freeable Memory
Burst Balance
Network Receive Throughput
Network Transmit Throughput
Free Storage Space
Read Latency
Write Latency
Read Throughput
Write Throughput
Read IOPS
Write IOPS
Disk Queue Depth
Swap Usage
Database Connections
Maximum Used Transaction ID
Transaction Log Disk Usage
Transaction Logs Generation
Oldest Replica Slot Lag
Replica Lag
Replica Slot Disk Usage

Prerequisites

Windows PowerShell needs to be configured to run scripts
Install AWS Tools for PowerShell - Installing the AWS Tools for PowerShell on Windows - AWS Tools for PowerShell
- Make sure to install the tools globally for all users.
- The template requires: AWS.Tools.RDS, AWS.Tools.CloudWatch
Restart of SolarWinds Job Engine service might be required when version of the AWS Tools changes.
Update paths to the installed AWS Tools in the template script to point to correct location/version of the assemblies.
Update the $region and $rdsinstanceid in the template script to reflect which RDS instance you want to monitor.

Credentials

The user should have SAM Administrator permissions.
As credentials for the template use combination of Access Key as username and Secret Key as password.

Monitored Components

CPU Utilization
- The percentage of CPU utilization.
- Unit: Percent
Freeable Memory
- The amount of available random access memory.
  For MariaDB, MySQL, Oracle, and PostgreSQL DB instances, this metric reports the value of the MemAvailable field of /proc/meminfo.
- Unit: Bytes
Burst Balance
- The percent of General Purpose SSD (gp2) burst-bucket I/O credits available.
- Unit: Percent
Network Receive Throughput
- The incoming (receive) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication.
- Unit: Bytes per second
Network Transmit Throughput
- The outgoing (transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication.
- Unit: Bytes per second
Free Storage Space
- The amount of available storage space.
- Unit: Bytes
Read Latency
- The average amount of time taken per disk I/O operation.
- Unit: Seconds
Write Latency
- The average amount of time taken per disk I/O operation.
- Unit: Seconds
Read Throughput
- The average number of bytes read from disk per second.
- Unit: Bytes per second
Write Throughput
- The average number of bytes written to disk per second.
- Unit: Bytes per second
Read IOPS
- The average number of disk read I/O operations per second.
- Unit: Count per second
Write IOPS
- The average number of disk write I/O operations per second.
- Unit: Count per second
Disk Queue Depth
- The number of outstanding I/Os (read/write requests) waiting to access the disk.
- Unit: Count
Swap Usage
- The amount of swap space used on the DB instance. This metric is not available for SQL Server.
- Unit: Bytes
Database Connections
- The number of client network connections to the database instance.
  The number of database sessions can be higher than the metric value because the metric value doesn't include the following:
  - Sessions that no longer have a network connection but which the database hasn't cleaned up
  - Sessions created by the database engine for its own purposes
  - Sessions created by the database engine's parallel execution capabilities
  - Sessions created by the database engine job scheduler
  - Amazon RDS connections
- Unit: Count
Maximum Used Transaction ID
- The maximum transaction IDs that have been used. Applies to only PostgreSQL.
- Unit: Count
Transaction Log Disk Usage
- The disk space used by transaction logs. Applies to PostgreSQL.
- Unit: Bytes
Transaction Logs Generation
- The size of transaction logs generated per second. Applies to PostgreSQL.
- Unit: Bytes
Oldest Replica Slot Lag
- The lagging size of the replica lagging the most in terms of write-ahead log (WAL) data received. Applies to PostgreSQL.
- Unit: Bytes
Replica Lag
- For read replica configurations, the amount of time a read replica DB instance lags behind the source DB instance. Applies to MariaDB, Microsoft SQL Server, MySQL, Oracle, and PostgreSQL read replicas.
  For Multi-AZ DB clusters, the difference in time between the latest transaction on the writer DB instance and the latest applied transaction on a reader DB instance.
- Unit: Seconds
Replica Slot Disk Usage
- The disk space used by replication slot files. Applies to PostgreSQL.
- Unit: Bytes

Troubleshooting steps

Detail troubleshooting steps (common for template)

Make sure that AWS Tools are installed globally.
Confirm that paths to AWS Tools assemblies are correct and those files are available on the machine.
Make sure that the template is using same platform as for which the AWS Tools were installed.
Try to restart SolarWinds Job Engine service in case that you get assembly load issues.