Skip to content

Databases

All inefficiencies

Each entry explains the waste, the billing model behind it, how to detect it and how to fix it.

114 inefficiencies

  • DatabricksCER-0332

    Missing Partition Pruning in Delta Lake Table Queries

    When Delta Lake tables are partitioned by specific columns - such as date, region, or tenant identifier - the query engine can use partition pruning to limit data scans to only the relevant subset of files. However, when queries against...

    Databases

  • MongoDB AtlasCER-0326

    Continuous Backup Enabled on Non-Production MongoDB Atlas Clusters

    MongoDB Atlas offers two backup mechanisms for dedicated clusters: Cloud Backups (scheduled snapshots using the underlying cloud provider's native snapshot functionality) and Continuous Cloud Backup, which adds point-in-time recovery by...

    Databases

  • AWS RDSCER-0323

    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 ElastiCacheCER-0321

    Suboptimal Cache TTL Strategy Causing Repeated Backend Execution

    Organizations deploy ElastiCache to reduce load on backend systems - databases, APIs, and compute layers - by serving frequently accessed data from fast in-memory storage. However, when Time-to-Live (TTL) values are misaligned with actual...

    Databases

  • AWS RDSCER-0320

    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

  • Azure Cache for RedisCER-0310

    Overprovisioned Azure Cache for Redis Instance

    Azure Cache for Redis is billed at a fixed rate determined entirely by the provisioned tier and cache size - not by actual utilization. A cache instance that consumes only a fraction of its available memory and throughput incurs the same...

    Databases

  • AWS RDSCER-0299

    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

  • GCP BigQueryCER-0295

    Overselecting Data and Misusing LIMIT for Cost Control in BigQuery

    Analysts use SELECT * (reading more columns than needed) and/or rely on LIMIT as a cost-control mechanism. In BigQuery, projecting excess columns increases the amount of data read and can materially raise query cost, particularly on wide...

    Databases

  • Azure SQL Managed InstanceCER-0288

    Suboptimal Service Tier Selection in Azure SQL Managed Instance

    Azure SQL Managed Instances remain on the original General Purpose architecture, or on the separate premium Business Critical tier when they do not need its capabilities (low-latency local SSD storage and a built-in read-only replica),...

    Databases

Showing 12 of 114