How to monitor RDS using CLoudWatch

Question

Hi

I have an oracle 19c RDS instance running. Does RDS automatically publish all performance and other statistics data to CloudWatch or do I need to set this up manually?

Is there any good training video or article on how to read or use the CloudWatch data or graphs for monitoring?

Thanks

Accepted Answer

Hi,

I guess that this blog post is exactly what you're looking for: https://aws.amazon.com/blogs/database/monitor-real-time-amazon-rds-os-metrics-with-flexible-granularity-using-enhanced-monitoring/

This blog post is about best practices for RDS monitoring with SQL Server but it provides good inspiration for Oracle:
https://aws.amazon.com/blogs/database/part1-best-practices-on-how-to-configure-monitoring-and-alerts-for-amazon-rds-for-sql-server/

Best,

Didier

Answer

In general, yes, RDS publishes enough performance metrics to cloudwatch. There is an option to turn on enhanced monitoring, which will publish OS-level metrics to Cloudwatch. But, you will have to make the decision on if you need that level of monitoring.

Check the docs on RDS here: https://docs.aws.amazon.com/en_us/AmazonRDS/latest/UserGuide/CHAP_Monitoring.html

How to monitor RDS using CLoudWatch

Relevant content