CompTIA Cloud Essentials+ (CLO-002)Management and Technical OperationsEasy
A cloud operations team is investigating slow application response times. They suspect a bottleneck in the database layer, specifically with too many concurrent connections. Which of the following monitoring metrics would be MOST relevant to confirm this suspicion?
- ADisk I/O operations
- BNetwork egress bytes
- CDatabase active connections
- DCPU utilization
Show answer & explanationAnswer & explanation
Correct answer: C. Database active connections
The scenario directly points to 'too many concurrent connections' in the 'database layer' as the suspected bottleneck. Monitoring 'Database active connections' will directly confirm or deny this suspicion.
Why the other options are wrong
- A. Disk I/O operations relate to read/write speeds, which might be affected by too many queries, but 'active connections' is a more direct metric for the stated suspicion.
- B. Network egress bytes relate to data leaving the network, not directly to database connection issues.
- D. CPU utilization can be a symptom but doesn't directly confirm 'too many concurrent connections' as the cause.
Database Monitoring Metrics
Key performance indicators (KPIs) tracked to assess the health, performance, and resource utilization of a database system.
- Crucial for identifying bottlenecks and performance issues.
- Includes metrics like connections, queries per second, latency, CPU, memory, and disk I/O.
- Proactive monitoring helps prevent outages and optimize performance.
Memory trick: To find a database bottleneck, think 'CON-Q-LOAD': CONnections, Queries, and overall LOAD.