HPE0-S22 Exam QuestionsBrowse all questions from this exam
Go to Exam

HPE0-S22 Exam - Question 38

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?

Show Answer
Correct Answer: C

The MS-SQL database is experiencing performance issues primarily due to high I/O demands. Installing an HPE IO Accelerator on the blade will significantly enhance IOPS performance, potentially reaching up to 530,000 IOPS, which far exceeds the requirement of 100,000 IOPS. This solution directly addresses the I/O bottleneck and is more effective than adding local SSD drives or increasing memory, as it is specifically designed to handle high I/O workloads with lower latency.

Discussion

1 comment
Sign in to comment
dimitris_evoixOption: C
Mar 27, 2021

C is correct. An IO acceletator can reach up to 530.000 IOPS.