Submit feedback on
Suboptimal Service Tier Selection in Azure SQL Managed Instance
We've received your feedback.
Thanks for reaching out!
Oops! Something went wrong while submitting the form.
Close
Suboptimal Service Tier Selection in Azure SQL Managed Instance
Balazs Engedi
CER:
Azure-Databases-9578
Service Category
Databases
Cloud Provider
Azure
Service Name
Azure SQL Managed Instance
Inefficiency Type
Suboptimal service tier selection
Explanation

This inefficiency occurs when Azure SQL Managed Instances continue running on legacy General Purpose or Business Critical tiers despite the availability of the next-gen General Purpose tier. The newer tier enables more granular scaling of vCPU, memory, and storage, allowing workloads to better match actual resource needs. In many cases, workloads running on Business Critical—or overprovisioned legacy General Purpose—do not require the premium performance or architecture of those tiers and could achieve equivalent outcomes at lower cost by moving to next-gen General Purpose.

Relevant Billing Model

Azure SQL Managed Instance is billed based on service tier, vCPU, memory, and storage configuration. The next-gen General Purpose tier offers improved performance characteristics and independent scaling of compute and storage at similar base pricing to legacy tiers, while Business Critical incurs higher infrastructure and licensing costs.

Detection
  • Review which SQL Managed Instances are running on legacy General Purpose or Business Critical tiers
  • Assess whether workloads truly require Business Critical capabilities (e.g., low-latency IO, high concurrency)
  • Identify instances where compute, memory, or storage appear overprovisioned relative to workload needs
  • Evaluate whether current tier selection reflects historical constraints rather than current platform options
Remediation
  • Migrate eligible SQL Managed Instances to the next-gen General Purpose tier
  • Rebalance vCPU, memory, and storage independently to align with actual workload requirements
  • Periodically reassess tier selection as platform capabilities and pricing evolve
Submit Feedback