A systems administrator is diagnosing performance issues on a web application.

CompTIA CV0-003 Question Answer

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?

Increase CPU resources on the database server.

Increase caching on the database server.

Put the storage and the database on the same VLAN.

Enable compression on storage traffic.

Enable deduplication on the storage appliance.