AWS Certified SysOps Administrator – AssociateMonitoring, Logging, and RemediationMedium
A company is experiencing intermittent performance issues with its web application. They suspect the database might be the bottleneck. The database runs on an Amazon RDS for MySQL instance. The SysOps team needs to collect detailed performance metrics, including SQL queries, query execution plans, and wait events, to diagnose the problem without significantly impacting database performance. Which AWS service and feature should they use?
- AAWS X-Ray with database tracing enabled
- BAmazon CloudWatch Logs with custom log groups
- CAmazon RDS Performance Insights
- DAmazon CloudWatch with enhanced monitoring
Show answer & explanationAnswer & explanation
Correct answer: C. Amazon RDS Performance Insights
Amazon RDS Performance Insights is specifically designed to help analyze and troubleshoot performance issues in RDS databases by collecting and visualizing detailed diagnostic data, including SQL queries, wait events, and database load.
Why the other options are wrong
- A. X-Ray is for distributed tracing of applications, not for detailed performance analysis of an RDS database's internal operations like SQL queries or wait events.
- B. CloudWatch Logs can collect database logs, but it doesn't inherently provide the detailed performance analysis features like query plans or wait events that Performance Insights offers.
- D. CloudWatch Enhanced Monitoring for RDS provides OS-level metrics, but it does not offer the granular SQL query and wait event analysis that Performance Insights delivers.
RDS Performance Insights
Amazon RDS Performance Insights is a database performance monitoring tool that helps you quickly assess the load on your database and pinpoint performance bottlenecks.
- Visualizes database load and wait events.
- Identifies top SQL queries, hosts, users.
- Diagnoses and troubleshoots performance issues for RDS databases.
Memory trick: Performance Insights gives the 'inside' scoop on database bottlenecks.