Which of the following will BEST resolve these performance issues?

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,100Kbps.

Disk throughput: 382,700Kbps

The administrator also looks at the storage for the database server and notices it is consistently near its OPS limit.

Which of the following will BEST resolve these performance issues?
A . Increase CPU resources on the database server.
B . Increase caching on the database server.
C . Put the storage and the database on the same VLAN.
D . Enable compression on storage traffic.
E . Enable deduplication on the storage appliance.

View Answer

Answer: B

Explanation:

The performance issue is caused by the high demand of complex SQL queries on the database server, which consumes a lot of RAM and disk throughput. Increasing caching on the database server would reduce the number of disk reads and writes, as well as improve the response time of the queries by storing frequently accessed data in memory. This would be the best solution to resolve the performance issue.

Reference: CompTIA Cloud+ Certification Exam Objectives, Domain 4.0 Troubleshooting, Objective 4.3 Given a scenario, troubleshoot capacity issues within a cloud environment.