CV0-003 · Question #921
A systems administrator is diagnosing performance issues on a web application. The web application sends thousands of extremely complex SQL queries to a database server, which has trouble retrieving t
The correct answer is B. Increase caching on the database server.. The high RAM usage (97%) and the database storage being near its IOPS limit suggest that the database is frequently performing disk-intensive operations. Since disk throughput is nearly maxed out, increasing caching can help reduce the number of disk reads and improve query Cachi
Question
A systems administrator is diagnosing performance issues on a web application. The web application sends thousands of extremely complex SQL queries to a database server, which has trouble retrieving the information in time. The administrator checks the database server and notes the following resource utilization:
- CPU: 64%
- RAM: 97%
- Network throughput: 384/1000 Kbps
- Disk throughput: 382,700 Kbps
The administrator also notices that the storage for the database server is consistently near its IOPS limit. Which of the following will best resolve these performance issues?
Options
- AIncrease CPU resources on the database server.
- BIncrease caching on the database server.
- CPut the storage and the database on the same VLAN.
- DEnable compression on storage traffic.
- EEnable deduplication on the storage appliance.
How the community answered
(26 responses)- A19% (5)
- B62% (16)
- C12% (3)
- D4% (1)
- E4% (1)
Explanation
The high RAM usage (97%) and the database storage being near its IOPS limit suggest that the database is frequently performing disk-intensive operations. Since disk throughput is nearly maxed out, increasing caching can help reduce the number of disk reads and improve query Caching stores frequently accessed data in memory (RAM), significantly reducing disk I/O operations, which is the primary bottleneck here.
Topics
Community Discussion
No community discussion yet for this question.