The Azure Portal does not have anywhere to view the current SQL MI quota limits. Quota limits are set per Subscription/Region pair.

The Quota blade does not contain any of this information. You may get some information from the error if you try and create or scale in SQLMI instance that would exceed the limits.

How can I extract this information or where in Azure Portal can I see this?

The Azure Portal does not have anywhere to view the current SQL MI quota limits. Quota limits are set per Subscription/Region pair.

The Quota blade does not contain any of this information. You may get some information from the error if you try and create or scale in SQLMI instance that would exceed the limits.

How can I extract this information or where in Azure Portal can I see this?

• azure
• powershell
• azure-cli
• azure-sql-managed-instance

Share Improve this question Follow edited Mar 26 at 7:56 Thom A 96.3k1111 gold badges6161 silver badges9595 bronze badges asked Mar 26 at 5:58 RohanRohan 59888 silver badges1313 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

Currently the Quota blade does not have a Provider specific to SQL MI.
There is also no other Portal feature where you can view the SQL MI quota limits.

The only current known way is through PowerShell in the Azure CLI.

The following script print all limits for each subscription / region pair where you already have an SQL MI instance pausing between each.

$subscriptions = Get-AzSubscription | Select-Object -ExpandProperty Name

foreach ($subscription in $subscriptions) {
    az account set --subscription $subscription
    $sqlmi_locations = @(az sql mi list --query "[].location" --output tsv)

    # Store unique locations list of SQL managed instances in a subscription
    $unique_sqlmi_location = @($sqlmi_locations | Sort-Object -Unique)

    # Display the quotas and utilization for SQL Managed instances in a location
    for ($i = 0; $i -lt $unique_sqlmi_location.Length; $i++) {
        $location = $unique_sqlmi_location[$i]
        $subname_context = $subscription
        $az_output = az sql list-usages --location $location --query "[].{SubName:'$subname_context', Location:'$location', DisplayName:displayName, CurrentValue:currentValue, Limit:limit}" -o table
        #Display the output of the quotas
        $az_output | Format-Table | Out-String | Write-Host
        pause
    }
}

For a single subscription/region you can run the following command where
$location = Azure region eg. australiaeast
$subname_context = your subscription name

az sql list-usages --location $location --query "[].{SubName:'$subname_context', Location:'$location', DisplayName:displayName, CurrentValue:currentValue, Limit:limit}" -o table