A company has an SAP HANA database running on an EC2 instance with multiple EBS volumes striped using LVM. The database is experiencing high latency during peak hours. Monitoring shows that the EBS volumes have a high Average Queue Length (avgqueue) and are frequently hitting the IOPS limit. The volumes are gp2 with 3000 IOPS each. The operations team wants to improve performance without increasing storage size. What should they do?
gp3 allows independent scaling of IOPS and throughput.
Why this answer
Option D is correct because changing the volume type to gp3 offers higher baseline IOPS (3000) and allows separate increase of IOPS and throughput without changing size. Option A is wrong because adding more gp2 volumes increases cost but may not address the bottleneck if the LVM is not balanced. Option B is wrong because instance store is ephemeral and not suitable for database.
Option C is wrong because io2 Block Express is for very high performance but may be overkill; gp3 is a better immediate step.