An administrator has a SQL VM running, which is experiencing high disk latency. What could the administrator do to alleviate this?

Question

Options

• AIncrease CPU and Memory on the CVM
• BAttach additional Volume Groups to the VM
• CAdd more CPU and Memory to the VM
• DCreate another Storage Container

• A
  3% (1)
• B
  20% (6)
• C
  7% (2)
• D
  70% (21)

Explanation

Creating a dedicated storage container for the SQL VM (D) allows the administrator to tune storage policies specifically for SQL workloads-for example, disabling inline compression and deduplication, which add CPU and latency overhead that is particularly detrimental to OLTP workloads that perform many small, random I/Os. Migrating the SQL VM's vDisks to this optimized container isolates it from other workloads and removes latency-inducing features. Adding CPU/Memory to the CVM (A) addresses compute bottlenecks on the storage controller, not storage policy tuning. Adding Volume Groups (B) provides iSCSI block storage but does not directly resolve policy-induced latency. Adding vCPU/RAM to the VM itself (C) improves compute resources, not storage throughput.

No community discussion yet for this question.