Amazon RDS

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.