What should a Database Specialist do in this situation to increase performance and return latency to sub-second levels?
Increase the size of the DB instance storage
Change the underlying EBS storage type to General Purpose SSD (gp2)
Disable EBS optimization on the DB instance
Change the DB instance to an instance class with a higher maximum bandwidth
Explanations:
Increasing the size of the DB instance storage may provide more storage capacity, but it won’t address the issue of low IOPS utilization or improve latency if bandwidth is already fully utilized.
General Purpose SSD (gp2) is not suited for high-performance applications requiring consistent high IOPS. Provisioned IOPS (PIOPS) is better for meeting the latency and throughput requirements.
Disabling EBS optimization could degrade performance as it would remove the dedicated connection to the storage, which is necessary for maximizing IOPS and minimizing latency.
Changing the DB instance to a larger instance class with higher bandwidth will provide more resources to handle the high throughput demands, improving performance and reducing latency.
If I had to guess, I’d say the answer is:
Change the DB instance to an instance class with a higher maximum bandwidth