# Suboptimal Service Tier Selection in Azure SQL Managed Instance

Canonical: https://www.pointfive.co/efficiency-hub/inefficiencies/suboptimal-service-tier-selection-in-azure-sql-managed-instance

[Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) 

# Suboptimal Service Tier Selection in Azure SQL Managed Instance

## 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

## Relevant Documentation

[https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/service-tiers-next-gen-general-purpose-use](https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/service-tiers-next-gen-general-purpose-use)

[Submit Feedback](https://hub.pointfive.co/inefficiencies/suboptimal-service-tier-selection-in-azure-sql-managed-instance)

## At a glance

Reference

CER-0288

Cloud provider

Azure

Service

Azure SQL Managed Instance

Category

[Databases](https://www.pointfive.co/efficiency-hub/service-category/databases)

Inefficiency type

Suboptimal service tier selection

## Contributed by

- Balazs Engedi 

### Balazs Engedi

FinOps Specialist @ KPN

[LinkedIn](https://www.linkedin.com/in/engedib/)

---
Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.