# AWS RDS optimization | Cloud Efficiency Hub Canonical: https://www.pointfive.co/efficiency-hub/cloud-services/aws-rds 19 documented AWS RDS cost inefficiencies, each with how to detect it and how to fix it. [Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) 19 documented AWS RDS cost inefficiencies, each with how to detect it and how to fix it. ## 19 inefficiencies [All services](https://www.pointfive.co/efficiency-hub#browse-by-service) - AWS RDS CER-0323 ### [RDS SQL Server Running Bundled Licensing on Older Instance Families](https://www.pointfive.co/efficiency-hub/inefficiencies/rds-sql-server-running-bundled-licensing-on-older-instance-families) Amazon RDS for SQL Server has traditionally used a License Included model where the SQL Server license cost is bundled into a single hourly instance price alongside Windows OS licensing, compute resources, and RDS management capabilities.... Databases - AWS RDS CER-0322 ### [Non-Production RDS SQL Server Using Standard or Enterprise Edition Instead of Developer Edition](https://www.pointfive.co/efficiency-hub/inefficiencies/non-production-rds-sql-server-using-standard-or-enterprise-edition-instead-of-developer-edition) Amazon RDS for SQL Server uses a License Included pricing model where the hourly instance rate bundles Microsoft SQL Server licensing fees on a per-vCPU basis. When non-production workloads - such as development, testing, staging, QA, or... Databases - AWS RDS CER-0320 ### [Excess vCPU Licensing Costs on RDS for SQL Server Instances](https://www.pointfive.co/efficiency-hub/inefficiencies/excess-vcpu-licensing-costs-on-rds-for-sql-server-instances) Amazon RDS for SQL Server uses a License Included pricing model where SQL Server and Windows OS licensing costs are bundled into the per-instance-hour rate - and those licensing costs scale directly with the number of vCPUs on the... Databases - AWS RDS CER-0299 ### [Orphaned RDS Backup Storage After Database Deletion](https://www.pointfive.co/efficiency-hub/inefficiencies/orphaned-rds-backup-storage-after-database-deletion) An RDS database instance is deleted but its manual snapshots or retained backups remain. Unlike automated backups tied to a live instance, these backups persist independently and continue generating storage costs despite no longer... Databases - AWS RDS CER-0206 ### [Outdated RDS Versions Triggering Extended Support Charges](https://www.pointfive.co/efficiency-hub/inefficiencies/outdated-rds-versions-triggering-extended-support-charges) Many organizations continue to run outdated database engines, such as MySQL 5.7 or PostgreSQL 11, beyond their support windows. Beginning in 2024, AWS automatically enrolls these into Extended Support to maintain security updates, adding... Databases - AWS RDS CER-0055 ### [Excessive Retention of Automated RDS Backups](https://www.pointfive.co/efficiency-hub/inefficiencies/excessive-retention-of-automated-rds-backups) If backup retention settings are too high or old automated backups are unnecessarily retained, costs can accumulate rapidly. RDS backup storage is significantly more expensive than equivalent storage in S3. For long-term retention or... Databases - AWS RDS CER-0210 ### [Unnecessary Multi-AZ Configuration for Non-Production RDS Instances](https://www.pointfive.co/efficiency-hub/inefficiencies/unnecessary-multi-az-configuration-for-non-production-rds-instances) RDS Multi-AZ deployments are designed for production-grade fault tolerance. In non-production environments, a Multi-AZ DB instance deployment roughly doubles the cost of database instances and storage, and a Multi-AZ DB cluster runs three... Databases - AWS RDS CER-0205 ### [Inefficient Use of RDS Reader Nodes](https://www.pointfive.co/efficiency-hub/inefficiencies/inefficient-use-of-rds-reader-nodes) RDS reader nodes are intended to handle read-only workloads, allowing for traffic offloading from the primary (writer) node. However, in many environments, services are misconfigured or hardcoded to send all traffic - including reads-to... Databases - AWS RDS CER-0030 ### [Underutilized RDS Commitment Due to Workload Drift](https://www.pointfive.co/efficiency-hub/inefficiencies/underutilized-rds-commitment-due-to-workload-drift) RDS workloads often evolve - changing engine types, rightsizing instances, or shifting to Aurora or serverless models. When these changes occur after Reserved Instances have been purchased, the existing commitments may no longer match... Databases - AWS RDS CER-0119 ### [Non-Graviton RDS Instance on Eligible Workload](https://www.pointfive.co/efficiency-hub/inefficiencies/non-graviton-rds-instance-on-eligible-workload) Many RDS workloads continue to run on older x86 instance types (e.g., db.m5, db.r5) even though compatible Graviton-based options (e.g., db.m6g, db.r6g) are widely available. These newer families deliver improved performance per vCPU and... Databases - AWS RDS CER-0097 ### [No Lifecycle Management for Temporarily Stopped RDS Instances](https://www.pointfive.co/efficiency-hub/inefficiencies/no-lifecycle-management-for-temporarily-stopped-rds-instances) While stopping an RDS instance reduces runtime cost, AWS enforces a 7-day limit on stopped state. After this period, the instance is automatically restarted and resumes incurring compute charges - even if the database is still not needed.... Databases - AWS RDS CER-0086 ### [Suboptimal RDS Instance Storage Type](https://www.pointfive.co/efficiency-hub/inefficiencies/suboptimal-rds-instance-storage-type) An RDS instance uses a high-cost storage type such as io1 or io2 but does not require the performance benefits it provides. In many cases, provisioned IOPS are set at or below the free baseline included with gp3 (3,000 IOPS and 125 MiB/s,... Databases - AWS RDS CER-0065 ### [Inactive RDS Instance](https://www.pointfive.co/efficiency-hub/inefficiencies/inactive-rds-instance) An RDS instance remains in the running state but is no longer actively serving application traffic. These instances may be remnants of retired applications, paused development environments, or workloads that were migrated elsewhere. If an... Databases - AWS RDS CER-0015 ### [Underutilized RDS Instance](https://www.pointfive.co/efficiency-hub/inefficiencies/underutilized-rds-instance) An RDS instance is consistently operating below its provisioned capacity - for example, showing low CPU, or memory utilization over an extended period. This often results from conservative initial sizing, decreased workload demand, or... Databases - AWS RDS CER-0082 ### [Oversized RDS Instance Storage](https://www.pointfive.co/efficiency-hub/inefficiencies/oversized-rds-instance-storage) An RDS instance is allocated significantly more storage than it consumes. For example, a 2TB volume might contain only 150GB of actual data. Since RDS does not allow reducing allocated storage on existing instances, these volumes continue... Databases - AWS RDS CER-0064 ### [Inactive RDS Cluster](https://www.pointfive.co/efficiency-hub/inefficiencies/inactive-rds-cluster) An RDS cluster remains provisioned but is no longer serving any workloads and has no active database connections. Unlike underutilized resources, these clusters are completely idle-showing no query activity, background processing, or usage... Databases - AWS RDS CER-0072 ### [Long-Retained RDS Manual Snapshot](https://www.pointfive.co/efficiency-hub/inefficiencies/long-retained-rds-manual-snapshot) Manual snapshots are often created for operational tasks like upgrades, migrations, or point-in-time backups. Unlike automated backups, which are automatically deleted after a set retention period, manual snapshots remain in place until... Databases - AWS RDS CER-0036 ### [Inactive RDS Read Replica](https://www.pointfive.co/efficiency-hub/inefficiencies/inactive-rds-read-replica) Read replicas are intended to improve performance for read-heavy workloads or support cross-region redundancy. However, it's common for replicas to remain in place even after their intended purpose has passed. In some cases, they were... Databases - AWS RDS CER-0370 ### [Low Commitment Coverage for Steady-State RDS and Aurora Databases](https://www.pointfive.co/efficiency-hub/inefficiencies/low-commitment-coverage-for-steady-state-rds-and-aurora-databases) Production RDS and Aurora databases are among the most predictable workloads in an AWS account: they typically run 24 hours a day on the same instance class for long periods. When that usage is not covered by reserved DB instances or... Databases ## More AWS services - [AWS EC2 23](https://www.pointfive.co/efficiency-hub/cloud-services/aws-ec2) - [AWS S3 15](https://www.pointfive.co/efficiency-hub/cloud-services/aws-s3) - [AWS Lambda 12](https://www.pointfive.co/efficiency-hub/cloud-services/aws-lambda) - [AWS EBS 10](https://www.pointfive.co/efficiency-hub/cloud-services/aws-ebs) - [AWS CloudWatch 8](https://www.pointfive.co/efficiency-hub/cloud-services/aws-cloudwatch) - [AWS EKS 8](https://www.pointfive.co/efficiency-hub/cloud-services/aws-eks) - [AWS ElastiCache 8](https://www.pointfive.co/efficiency-hub/cloud-services/aws-elasticache) - [AWS DynamoDB 7](https://www.pointfive.co/efficiency-hub/cloud-services/aws-dynamodb) - [AWS Bedrock 6](https://www.pointfive.co/efficiency-hub/cloud-services/aws-bedrock) - [AWS ELB 6](https://www.pointfive.co/efficiency-hub/cloud-services/aws-elb) --- Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.