Which solution will meet this requirement with the LEAST operational overhead?
Publish RDS Performance insights metrics to Amazon CloudWatch. Add AWS CloudTrail filters to monitor database performance
Install Oracle Statspack. Enable the performance statistics feature to collect, store, and display performance data to monitor database performance.
Enable RDS Performance Insights to visualize the database load. Enable Enhanced Monitoring to view how different threads use the CPU
Create a new DB parameter group that includes the AllocatedStorage, DBInstanceClassMemory, and DBInstanceVCPU variables. Enable RDS Performance Insights
Explanations:
While CloudWatch can monitor RDS metrics, using CloudTrail filters for database performance is unnecessary and adds complexity, increasing operational overhead.
Installing Oracle Statspack requires manual configuration and management, which increases operational overhead. Additionally, this option doesn’t fully integrate with Amazon RDS for automated monitoring.
Enabling RDS Performance Insights with Enhanced Monitoring is a fully managed solution by AWS, providing minimal operational overhead while giving detailed database performance insights, including latency and thread usage.
Creating a new DB parameter group with specific variables does not address monitoring latency or performance. It is more for configuration purposes and doesn’t provide an integrated monitoring solution.
I rank that the answer is:
Enable RDS Performance Insights to visualize the database load. Enable Enhanced Monitoring to view how different threads use the CPU