Measure Database Load and Identify High CPU SQL Commands
Question
A development team is experiencing performance issues with their Amazon RDS instance.
They wish to measure database load and identify SQL commands with a high CPU load.
What service can the team use to help them solve this issue?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.Answer: D.
Option A is incorrect because CloudTrail is a service for logging and storing AWS account and service API activity, not application logs.
CloudTrail Insights is a feature that helps identify and alert any abnormal activity in the AWS account.
Option B is incorrect because CloudWatch collects performance metrics of EC2 instances, not Amazon RDS instances.
Further, it collects host-level metrics and cannot identify issues relating to individual SQL queries.
Option C is incorrect because AWS Inspector is a network and security assessment service.
It performs an assessment of EC2 instances for network vulnerabilities (e.g., exposed ports), Common Vulnerabilities and Exposures (CVE), and compares OS configurations to CIS security benchmarks.
It is not used for collecting logs or correlating errors.
Option D is CORRECT because Amazon RDS Performance Insights collects key performance metrics of Amazon RDS DB instances and identifies SQL queries that create high database load.
It can help in tuning and improving RDS database performance.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.htmlThe service that the development team can use to measure database load and identify SQL commands with a high CPU load on their Amazon RDS instance is D. RDS Performance Insights.
RDS Performance Insights is a performance monitoring feature that helps monitor the performance of Amazon RDS database instances. It provides a dashboard that displays a comprehensive view of the database instance's load, latency, and input/output operations per second (IOPS) over time. This allows users to identify performance issues in real-time and drill down to the specific SQL commands that are causing high CPU load.
Additionally, Performance Insights provides the ability to analyze and visualize database performance metrics by specifying a custom time range or filtering based on specific database dimensions. It also provides recommendations for query optimization by identifying high impact queries and displaying detailed performance data for each query.
CloudTrail Insights Events is a service that helps detect unusual activity in AWS resources by analyzing CloudTrail log data. It is not relevant to solving performance issues in Amazon RDS instances.
CloudWatch Enhanced Monitoring is a service that provides additional monitoring capabilities beyond the basic monitoring provided by Amazon CloudWatch. It enables users to monitor the operating system and applications running on Amazon EC2 instances. It is not relevant to solving performance issues in Amazon RDS instances.
Inspector assessment report is a security assessment service that helps improve the security and compliance of applications deployed on AWS infrastructure. It is not relevant to solving performance issues in Amazon RDS instances.
