CLOUD-DEPLOYMENT-AND-OPERATIONS practice question 12 of 15

(Which Performance Insights view provides information on the hardware resource that may be causing a bottleneck?)

Full set: 67 questions
Answer options
A: Wait event Correct answer
B: Users
C: Hosts
D: Statement
Correct Answer:
A. Wait event
Explanation

The AWS Performance Insights "Wait event" view is the primary tool for identifying resource bottlenecks. This view breaks down the database load by what the database engine is waiting for. If the top wait events are CPU, it indicates a CPU bottleneck. Similarly, if wait events like io/file/read or io/file/write are dominant, it points to a storage (I/O) bottleneck. By analyzing the types of waits consuming the most time, an administrator can directly identify which specific hardware resource is constrained and causing the performance issue.

Why Incorrect

B. Users: This view shows which database user accounts are generating load, not which hardware resource is the bottleneck.
C. Hosts: This view identifies which client hosts are connected and generating load, not the constrained hardware resource on the database server.
D. Statement: This view pinpoints the specific SQL queries causing high load but does not directly identify the underlying hardware resource bottleneck.

References

1. Amazon RDS User Guide, "Wait events" section: "When you tune a database, you often try to find out what resources the engine is waiting for. For example, sessions might be waiting for buffers in memory to be freed, data files to be read, or logs to be written. These resources are called wait events." This directly links wait events to resource contention.

Source: AWS Documentation, Amazon RDS User Guide, Section: "Wait events". Retrieved from https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USERPerfInsights.Concepts.html#USERPerfInsights.Concepts.Waits

2. Amazon RDS User Guide, "Database load" section: The documentation explains that the database load (DB load) chart can be sliced by dimensions, with "Waits" being a key dimension. "The Waits dimension groups the DB load by wait event. This view shows you which wait events are contributing the most to DB load." This confirms that analyzing waits is the intended method for understanding the cause of load.

Source: AWS Documentation, Amazon RDS User Guide, Section: "Database load". Retrieved from https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USERPerfInsights.TheDashboard.html#USERPerfInsights.TheDashboard.DBLoad

Scroll to Top