RDS Events versus CloudWatch Alarms

0

Hi

I have an oracle 19c running on RDS in AWS.

I need to setup some monitoring alarms in case DB goes down, CPU utilization goes over 80%, RDS deletion, etc. and received an email alert.

I noticed AWS has several monitoring tools: RDS Server Events, CloudWatch alarms, Enhanced monitoring and Performance Insights.

How do you know which is the most appropriate to use to setup email alerts or notifications in this case? Are RDS Server events different than cloudwatch alarms?

Thanks,

1 Answer
1
Accepted Answer

Hello.

CloudWatch alarms are configured based on RDS CloudWatch metrics.
For example, for CPU usage, set an alarm based on a threshold you set using a metric called "CPUUtilization."
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-metrics.html
https://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/AlarmThatSendsEmail.html

RDS server events are a feature that is detected by RDS events.
For example, events such as RDS being restarted or stopped can be detected.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.Messages.html

So, if you want to receive email notifications when CPU usage exceeds 80%, use CloudWatch alarms.
RDS deletion events can be detected using RDS server events.

profile picture
EXPERT
answered 7 months ago
  • Great Answer! There is a lot of RDS events and Cloud watch metrics that can be used for monitoring and alarms. Is there an article or link that shows that is the best practice or the standard ones that a DBA should track?

  • I think it's a good idea to decide monitoring items not based on the database you're using, but based on what the application that uses the database does. For example, if your application writes a lot to the database, you may want to monitor "WriteLatency" to see if the write speed is slowing down. Therefore, the monitoring items will change depending on the application you are using, so we recommend consulting with the application creator.

  • I will check with applciation vendor but I really doubt they would tell me what to monitor on the DB side for application. You might have same application in Corp A with 50 users with very low writes and same applicatin in Corp B with 500 users doing a lot of writes. Application Usage might vary from company to another.

  • In that case, I think it's a good idea to decide which metrics to monitor based on the items you value.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions