AWS RDS Instance Monitoring

AWS RDS Instance Monitoring

AWS RDS instance monitoring

Hello Everyone

Welcome to CloudAffaire and this is Debjeet.

In the last blog post, we have discussed how to restore an AWS RDS instance using snapshot.

https://cloudaffaire.com/how-to-restore-an-aws-rds-instance-using-snapshot

Monitoring is an important part of maintaining the reliability, availability, and performance of Amazon RDS. AWS RDS by default collects lots of metrics from your instance that you can leverage to monitor your instance effectively. In this blog post, we will discuss how to monitor an AWS RDS instance using CloudWatch metrics. Below is a list of metrics that are collected by default.

  • BinLogDiskUsage(Units: Bytes): The amount of disk space occupied by binary logs on the master. Applies to MySQL read replicas.
  • BurstBalance(Units: Percent): The percent of General Purpose SSD (gp2) burst-bucket I/O credits available.
  • CPUUtilization(Units: Percent): The percentage of CPU utilization.
  • CPUCreditUsage(Units: Credits): The number of CPU credits spent by the instance for CPU utilization.
  • CPUCreditBalance(Units: Credits): The number of earned CPU credits that an instance has accrued since it was launched or started.
  • DatabaseConnections(Units: Count): The number of database connections in use.
  • DiskQueueDepth(Units: Count): The number of outstanding IOs (read/write requests) waiting to access the disk.
  • FailedSQLServerAgentJobsCount(Unit: Count/Minute): The number of failed SQL Server Agent jobs during the last minute.
  • FreeableMemory(Units: Bytes): The amount of available random access memory.
  • FreeStorageSpace(Units: Bytes): The amount of available storage space.
  • MaximumUsedTransactionIDs(Units: Count): The maximum transaction ID that has been used. Applies to PostgreSQL.
  • NetworkReceiveThroughput(Units: Bytes/Second): The incoming network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication.
  • NetworkTransmitThroughput(Units: Bytes/Second): The outgoing network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication.
  • OldestReplicationSlotLag(Units: Megabytes): The lagging size of the replica lagging the most in terms of WAL data received. Applies to PostgreSQL.
  • ReadIOPS(Units: Count/Second): The average number of disk read I/O operations per second.
  • ReadLatency(Units: Seconds): The average amount of time taken per disk I/O operation.
  • ReadThroughput(Units: Bytes/Second): The average number of bytes read from disk per second.
  • ReplicaLag(Units: Seconds): The amount of time a Read Replica DB instance lags behind the source DB instance. Applies to MySQL, MariaDB, and PostgreSQL Read Replicas.
  • ReplicationSlotDiskUsage(Units: Megabytes): The disk space used by replication slot files. Applies to PostgreSQL.
  • SwapUsage(Units: Bytes): The amount of swap space used on the DB instance. This metric is not available for SQL Server.
  • TransactionLogsDiskUsage(Units: Megabytes): The disk space used by transaction logs. Applies to PostgreSQL.
  • TransactionLogsGeneration(Units: Bytes/Second): The size of transaction logs generated per second. Applies to PostgreSQL.
  • WriteIOPS(Units: Count/Second): The average number of disk write I/O operations per second.
  • WriteLatency(Units: Seconds): The average amount of time taken per disk I/O operation.
  • WriteThroughput(Units: Bytes/Second): The average number of bytes written to disk per second.

Note: Some of the matrices are instance specific and only available for the specific instance types.

Next, we are going to explore how to monitor your RDS instance from AWS management console.

Prerequisites for this demo:

  • AWS RDS instance.

AWS RDS instance monitoring:

Step 1: Login to AWS console and navigate to ‘RDS’.

AWS RDS Instance Monitoring

Step 2: In the navigation pane under ‘Database’, click on the database instance that you want to monitor.

AWS RDS Instance Monitoring

Step 3: Navigate to ‘Monitoring’ tab and select the metrics that you want to monitor.

AWS RDS Instance Monitoring

AWS RDS Instance Monitoring

Note: You can change the metrics and customize the view using dropdowns.

Hope you have enjoyed this article, In the next blog post, we will discuss AWS RDS enhanced monitoring.

To get more details on AWS RDS, please refer below AWS documentation

https://docs.aws.amazon.com/rds/index.html

 

Leave a Reply

Close Menu