What should the database specialist do to improve the performance of the application immediately?

By:
In: DBS-C01
Tagged:
With: 1 Comment
A database specialist is working on an Amazon RDS for PostgreSQL DB instance that is experiencing application performance issues due to the addition of new workloads.The database has 5 ื€ยขื€โ€™ of storage space with Provisioned IOPS.Amazon CloudWatch metrics show that the average disk queue depth is greater than200 and that the disk I/O response time is significantly higher than usual.

What should the database specialist do to improve the performance of the application immediately?

Increase the Provisioned IOPS rate on the storage.

Increase the available storage space.

Use General Purpose SSD (gp2) storage with burst credits.

Create a read replica to offload Read IOPS from the DB instance.

Explanations:

Increasing the Provisioned IOPS rate will directly address the high disk I/O response time and high disk queue depth by providing more IOPS capacity, which helps to handle the additional workload.

Increasing storage space does not directly address the disk I/O performance issues. The issue is related to IOPS, not the amount of storage available.

General Purpose SSD (gp2) is not suitable for high-performance applications requiring consistent, high IOPS. Provisioned IOPS (io1) offers better performance for such workloads.

Creating a read replica helps offload read queries, but it does not address the underlying disk I/O performance problem on the primary DB instance, which is causing the high response time.

2025-10-06

1 Comment

  1. Cynthia
    Author

    My best guess is:
    Increase the Provisioned IOPS rate on the storage.

Leave a Reply

Your email address will not be published. Required fields are marked *

20 − fourteen =