A SysOps administrator is investigating issues on an Amazon RDS for MariaDB DB instance. The SysOps administrator wants to display the database load categorized by detailed wait events. How can the SysOps administrator accomplish this goal?
A.
Create an Amazon CloudWatch dashboard.
B.
Enable Amazon RDS Performance Insights.
C.
Enable and configure Enhanced Monitoring.
D.
Review the database logs in Amazon CloudWatch Logs.
CPU utilization and database load can be related, but they are independent of each other. A database can be under high load, but have low CPU utilization. Likewise, a CPU could be experiencing high utilization levels, but be running only a few queries.
Performance Insights is a feature of Amazon RDS that provides visibility into the performance of SQL queries inside RDS databases.
Correct answer B
"With the Performance Insights dashboard, you can visualize the database load on your Amazon RDS DB instance load and filter the load by waits, SQL statements, hosts, or users."
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.html
Instead Enhance monitoring Amazon RDS provides metrics in real time for the operating system (OS) that your DB instance runs on.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Monitoring.OS.overview.html
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.UsingDashboard.AnalyzeDBLoad.html
DB load grouped by waits and top SQL queries is the default Performance Insights dashboard view. This combination typically provides the most insight into performance issues. DB load grouped by waits shows if there are any resource or concurrency bottlenecks in the database. In this case, the SQL tab of the top load items table shows which queries are driving that load.
Your typical workflow for diagnosing performance issues is as follows:
Review the Database load chart and see if there are any incidents of database load exceeding the Max CPU line.
If there is, look at the Database load chart and identify which wait state or states are primarily responsible.
Identify the digest queries causing the load by seeing which of the queries the SQL tab on the top load items table are contributing most to those wait states. You can identify these by the DB Load by Wait column.
Choose one of these digest queries in the SQL tab to expand it and see the child queries that it is composed of.
To display the database load categorized by detailed wait events, the SysOps administrator should B, enable Amazon RDS Performance Insights. Performance Insights is an advanced performance monitoring feature that makes it easy to diagnose and solve performance problems on Amazon RDS. It displays the database load in an interactive graph, allowing you to analyze and troubleshoot the database workload. The load is categorized by SQL, waits, hosts, users, and other dimensions, providing detailed information about the sources of the load.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
CodePoet
Highly Voted 2 years, 11 months agoflaacko
Most Recent 7 months, 3 weeks agojames2033
1 year, 1 month agoTwinSpark
1 year, 6 months agoChristina666
1 year, 8 months agoChristina666
1 year, 8 months ago[Removed]
1 year, 9 months agomichaldavid
2 years, 4 months agoLiongeek
2 years, 5 months agoAtown
2 years, 5 months agoFinger41
2 years, 11 months ago