An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less than half of its CPU and RAM resources.
What should a Database Specialist do in this situation to increase performance and return latency to sub-second levels?
BillyMadison
Highly Voted 3 years, 7 months agoMultiAZ
Most Recent 1 year, 3 months agoPranava_GCP
1 year, 7 months agoIhorK
1 year, 8 months agolollyj
2 years, 4 months agonovice_expert
2 years, 11 months agokret
3 years agoguru_ji
3 years, 6 months agoLMax
3 years, 6 months agomyutran
3 years, 6 months agoRSSRAO
3 years, 6 months agoJobinAkaJoe
3 years, 6 months agoAshoks
3 years, 6 months agoAWSCert2020
3 years, 6 months agoAWSCert2020
3 years, 6 months agoBillyC
3 years, 6 months agoBillyC
3 years, 7 months ago