QuestionQ20

VerifiedSection 4 – Analyze and Remediate Performance Issues

An administrator is notified by a user that a Microsoft SQL Server instance is performing poorly.

When reviewing utilization metrics, the following concerns are observed:

  • Memory consumption has remained above 95% for several months.
  • Memory consumption has spiked to 100% for the last five days.
  • CPU usage is 45%.

Storage latency is 2 ms.

When logging in to Prism Central, how can the administrator quickly verify whether this VM has performance bottlenecks?

Explanation

The Prism Central VM Efficiency filter is intended to identify VMs with inefficient or constrained resource utilization. A VM with sustained memory consumption above 95% and recent 100% spikes can be rapidly surfaced and assessed through this filter, while moderate CPU use and low storage latency make memory pressure the likely bottleneck.

Community Discussion

No comments yet. Be the first to start the discussion!