HPE Server Solutions — Question 9

A customer has HPE BladeSystem BL460c Gen9 blades with two processors and 512GB of memory. The blades are running a MS-SQL database on a clustered
2TB SAS virtual volume that is exported from an HPE 3PAR StoreServ 8200. The customer reports that the MS-SQL database is performing poorly.
After extensive performance trending analysis, it is determined that the database front-end I/O requirements are unpredictable and often exceed 100,000 IOPs with latency in excess 30ms at critical times.
Which solution should the architect recommend to resolve the performance issue with consideration to cost and complexity?

Answer options

• A. Increase the memory on the blades to 2TB.
• B. Install SSD drives local to the BL460c.
• C. Install an HPE IO Accelerator on the blade.
• D. Add Adaptive Optimization licensing.

Correct answer: B

Explanation

Installing SSD drives local to the BL460c will provide faster read and write speeds, addressing the high IOPs and latency issues faced by the MS-SQL database. Increasing the memory may not directly resolve the I/O performance bottleneck, while the other options, such as the HPE IO Accelerator or Adaptive Optimization, could introduce more complexity and costs without guaranteeing the needed improvement in I/O performance.