A customer has a ProLiant DL-based server solution. The customer is experiencing I/O timeouts on their SQL data volume running on this solution. Which solution will increase the application…

Question

Options

• AUpgrade memory to 2666 MHz DDR4
• BUpgrade the current processor to a Xeon-Platinum
• CInstall an SSD drive and SmartCache license
• DInstall an SSD drive to host the log volume

• A
  3% (1)
• B
  76% (28)
• C
  8% (3)
• D
  14% (5)

Explanation

Upgrading to a Xeon Platinum processor provides significantly more PCIe lanes, increased memory bandwidth, and higher core counts - all of which directly expand the I/O throughput capacity of the server's storage subsystem, reducing latency and resolving timeout conditions under demanding SQL workloads.

Why the distractors are wrong:

• A (DDR4 2666 MHz): Faster memory helps memory-bound operations but doesn't address the storage I/O path causing timeouts on the data volume.
• C (SSD + SmartCache): SmartCache accelerates read caching, but the licensing/SSD combo still doesn't resolve underlying I/O bandwidth limitations at the controller and processor level - it masks rather than fixes the bottleneck.
• D (SSD for log volume): Moving the log volume to SSD improves sequential write performance for transaction logs, but the question states the problem is on the data volume, so this addresses the wrong volume.

Memory tip: Think "PCIe lanes = I/O highway lanes" - a Platinum processor widens the highway, while storage upgrades only affect one vehicle on it. When the question mentions the server platform itself as the bottleneck (not just a single disk), always look for the answer that upgrades the platform's core I/O capability.

No community discussion yet for this question.