# Azure SQL optimization | Cloud Efficiency Hub Canonical: https://www.pointfive.co/efficiency-hub/cloud-services/azure-sql 10 documented Azure SQL cost inefficiencies, each with how to detect it and how to fix it. [Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) 10 documented Azure SQL cost inefficiencies, each with how to detect it and how to fix it. ## 10 inefficiencies [All services](https://www.pointfive.co/efficiency-hub#browse-by-service) - Azure SQL CER-0264 ### [Suboptimal Use of Serverless Compute for Azure SQL Database](https://www.pointfive.co/efficiency-hub/inefficiencies/suboptimal-use-of-serverless-compute-for-azure-sql-database-4fe48) Serverless is attractive for variable or idle workloads, but it can become more expensive than Provisioned compute when database activity is high for long portions of the day. As active time increases, per-second compute accumulation... Databases - Azure SQL CER-0263 ### [Suboptimal Use of Provisioned Compute for Azure SQL Database](https://www.pointfive.co/efficiency-hub/inefficiencies/suboptimal-use-of-provisioned-compute-for-azure-sql-database-9bb83) Databases deployed on Provisioned compute incur continuous hourly charges even when workload demand is low. For databases that are active only briefly within an hour, or for limited hours per month, Serverless can provide significantly... Databases - Azure SQL CER-0239 ### [Azure Hybrid Benefit Not Enabled on SQL Databases](https://www.pointfive.co/efficiency-hub/inefficiencies/azure-hybrid-benefit-not-enabled-on-sql-databases-41927) Azure Hybrid Benefit allows organizations to apply existing SQL Server licenses with Software Assurance or qualifying subscriptions to Azure SQL Databases. When this configuration is missed or not enforced, workloads continue to incur... Databases - Azure SQL CER-0194 ### [Overbilling Due to Frequent Tier Switches in DTU Model](https://www.pointfive.co/efficiency-hub/inefficiencies/overbilling-due-to-tier-switches-and-allocation-overlaps-in-dtu-model) Workloads that frequently scale up and down within the same day-whether manually, via automation, or platform-managed-can encounter hidden cost amplification under the DTU model. Azure SQL Database bills each hour at the highest service... Databases - Azure SQL CER-0031 ### [Unnecessary Use of RA-GRS for Azure SQL Backup Storage](https://www.pointfive.co/efficiency-hub/inefficiencies/unnecessary-use-of-ra-grs-for-azure-sql-backup-storage) Azure SQL databases often use the default backup configuration, which stores backups in RA-GRS storage to ensure geo-redundancy. While suitable for high-availability production systems, this level of resilience may be unnecessary for... Databases - Azure SQL CER-0028 ### [Overprovisioned Compute Tier in Azure SQL Database](https://www.pointfive.co/efficiency-hub/inefficiencies/overprovisioned-compute-tier-in-azure-sql-database) Azure SQL Database resources are frequently overprovisioned due to default configurations, conservative sizing, or legacy requirements that no longer apply. This inefficiency appears across all deployment models: Single Databases may be... Databases - Azure SQL CER-0164 ### [Overprovisioned Storage in Azure SQL Elastic Pools or Managed Instances](https://www.pointfive.co/efficiency-hub/inefficiencies/overprovisioned-storage-in-azure-sql-elastic-pools-or-managed-instances) Azure SQL deployments often reserve more storage than needed, either due to default provisioning settings or anticipated future growth. Over time, if actual usage remains low, these oversized allocations generate unnecessary storage costs.... Databases - Azure SQL CER-0138 ### [Idle Azure SQL Elastic Pool Without Databases](https://www.pointfive.co/efficiency-hub/inefficiencies/idle-azure-sql-elastic-pool-without-databases) An Azure SQL Elastic Pool continues to incur costs even if it contains no databases. This can occur when databases are deleted, migrated to single-instance configurations, or consolidated elsewhere - but the pool itself remains... Databases - Azure SQL CER-0053 ### [Business Critical Tier on Non-Production SQL Instance](https://www.pointfive.co/efficiency-hub/inefficiencies/business-critical-tier-on-non-production-sql-instance) Non-production environments such as development, testing, or staging often do not require the high availability, failover capabilities, and premium storage performance offered by the Business Critical tier. Running these workloads on... Databases - Azure SQL CER-0434 ### [Missing Reservation or Savings Plan Coverage for Steady-State Azure SQL vCore Compute](https://www.pointfive.co/efficiency-hub/inefficiencies/missing-reservation-or-savings-plan-coverage-for-steady-state-azure-sql-vcore-compute) Provisioned vCore databases in Azure SQL Database and instances in Azure SQL Managed Instance are billed hourly for compute at pay-as-you-go rates unless a commitment discount applies. Production databases typically run around the clock at... Databases ## More Azure services - [Azure Virtual Machines 12](https://www.pointfive.co/efficiency-hub/cloud-services/azure-virtual-machines) - [Azure Cognitive Services 10](https://www.pointfive.co/efficiency-hub/cloud-services/azure-cognitive-services) - [Azure Managed Disks 9](https://www.pointfive.co/efficiency-hub/cloud-services/azure-managed-disks) - [Azure Blob Storage 7](https://www.pointfive.co/efficiency-hub/cloud-services/azure-blob-storage) - [Azure AKS 6](https://www.pointfive.co/efficiency-hub/cloud-services/azure-aks) - [Azure Cosmos DB 6](https://www.pointfive.co/efficiency-hub/cloud-services/azure-cosmos-db) - [Azure Database for PostgreSQL - Flexible Server 4](https://www.pointfive.co/efficiency-hub/cloud-services/azure-database-for-postgresql---flexible-server) - [Azure Log Analytics 4](https://www.pointfive.co/efficiency-hub/cloud-services/azure-log-analytics) - [Azure App Service 3](https://www.pointfive.co/efficiency-hub/cloud-services/azure-app-service) - [Azure App Service Plans 3](https://www.pointfive.co/efficiency-hub/cloud-services/azure-app-service-plans) --- Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.