Submit feedback on
Suboptimal Use of Provisioned Compute for Azure SQL Database
We've received your feedback.
Thanks for reaching out!
Oops! Something went wrong while submitting the form.
Close
Suboptimal Use of Provisioned Compute for Azure SQL Database
Benjamin van der Maas
CER:
Azure-Databases-2345
Service Category
Databases
Cloud Provider
Azure
Service Name
Azure SQL
Inefficiency Type
Incorrect Compute Tier Selection
Explanation

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 lower cost because it bills only for active compute time. The economic break-even point between Provisioned and Serverless depends on workload activity patterns. If monthly active time falls *below* the conceptual break-even range, Serverless is more cost-effective. If active time regularly exceeds that range, Provisioned may be more appropriate. This inefficiency typically appears when teams default to Provisioned compute without evaluating workload behavior over time.

Relevant Billing Model

Provisioned compute is billed per vCore-hour regardless of usage. Serverless compute is billed per vCore-second plus storage, and suspends compute charges during auto-pause. Selecting Provisioned for workloads with low or sporadic utilization results in paying for unused capacity.

Detection
  • Review whether database activity is intermittent or consistently low throughout the day
  • Assess whether monthly active time is substantially lower than the equivalent cost of Provisioned compute
  • Evaluate whether workload patterns include extended idle periods suitable for auto-pause
  • Check for development, testing, or sporadic workloads that do not require continuous compute availability
Remediation
  • Move the database to the Serverless compute tier when workloads are intermittent or have low active time
  • Use Serverless auto-pause capabilities to eliminate compute charges during idle periods
  • Periodically reassess compute model selection as application usage patterns evolve
  • Apply workload profiling to ensure that Serverless performance meets application needs before migration
Relevant Documentation
Submit Feedback