A systems administrator is diagnosing performance issues on

A systems administrator is diagnosing performance issues on - CompTIA Cloud+ CV0-004

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,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?

Answers

Increase CPU resources on the database server
correct

Increase caching on the database server
Put the storage and the database on the same VLA
Enable compression on storage traffic
Enable deduplication on the storage appliance

Explanation

Correct Answer: b. Increase caching on the database server

The database server shows high RAM usage (97%) and is reaching the IOPS (input/output operations per second) limit on its storage. This suggests that the server is heavily dependent on disk I/O due to complex SQL queries.

Increasing caching will allow more frequently accessed data to be stored in memory, reducing the number of disk operations needed. This improves query response time and reduces pressure on the storage subsystem, addressing the root cause.

Why the Other Choices Are Incorrect :

a. Increase CPU resources on the database server: The CPU usage is only at 64%, indicating it is not a bottleneck. Adding more CPU would not significantly improve performance since the main issue lies with I/O constraints and memory usage.
c. Put the storage and the database on the same VLA: VLA (likely a typo or misrepresentation of VLAN) relates to network segmentation. The issue is not related to network latency or segmentation; it's with storage and memory performance.
d. Enable compression on storage traffic: Compression reduces bandwidth usage but doesn't address disk IOPS limitations or RAM usage. Network throughput isn’t the bottleneck here.
e. Enable deduplication on the storage appliance: Deduplication reduces storage space usage, not IOPS. It may even increase CPU and memory load on the storage appliance, further worsening performance.

Easy way to pass your test within a week with prepsaret

You don’t need one month to study and pass your test.
With Prepsaret, it takes you a few days to grasp all the concepts needed to pass your exams

View Courses Offered