Skip to content

Latest commit

 

History

History
104 lines (66 loc) · 5.59 KB

capacity-errors-troubleshoot.md

File metadata and controls

104 lines (66 loc) · 5.59 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic ms.custom
Resolve capacity errors with Azure SQL resources
Learn how to resolve possible capacity errors when attempting to deploy or scale Azure SQL Database or Azure SQL Managed Instance resources.
sachinpMSFT
sachinp
mathoma, kendralittle
09/03/2021
sql-db-mi
deployment-configuration
how-to
references_regions

Resolve capacity errors with Azure SQL Database or Azure SQL Managed Instance

[!INCLUDEappliesto-sqldb-sqlmi]

In this article, learn how to resolve capacity errors when deploying Azure SQL Database or Azure SQL Managed Instance resources.

Exceeded quota

If you encounter any of the following errors when attempting to deploy your Azure SQL resource, please request to increase your quota:

  • Server quota limit has been reached for this location. Please select a different location with lower server count.
  • Could not perform the operation because server would exceed the allowed Database Throughput Unit quota of xx.
  • During a scale operation, you may see the following error:
    Could not perform the operation because server would exceed the allowed Database Throughput Unit quota of xx. .

Subscription access

Your subscription may not have access to create a server in the selected region if your subscription has not been registered with the SQL resource provider (RP).

If you see the following errors, please register your subscription with the SQL RP:

  • Your subscription does not have access to create a server in the selected region.
  • Provisioning is restricted in this region. Please choose a different region. For exceptions to this rule please open a support request with issue type of 'Service and subscription limits'
  • Location 'region name' is not accepting creation of new Windows Azure SQL Database servers for the subscription 'subscription id' at this time

Enable region

Your subscription may not have access to create a server in the selected region if that region has not been enabled. To resolve this, file a support request to enable a specific region for your subscription.

If you see the following errors, file a support ticket to enable a specific region:

  • Your subscription does not have access to create a server in the selected region.
  • Provisioning is restricted in this region. Please choose a different region. For exceptions to this rule please open a support request with issue type of 'Service and subscription limits'
  • Location 'region name' is not accepting creation of new Windows Azure SQL Database servers for the subscription 'subscription id' at this time

Register with SQL RP

To deploy Azure SQL resources, register your subscription with the SQL resource provider (RP).

You can register your subscription using the Azure portal, the Azure CLI, or Azure PowerShell.

Azure portal

To register your subscription in the Azure portal, follow these steps:

  1. Open the Azure portal and go to All Services.

  2. Go to Subscriptions and select the subscription of interest.

  3. On the Subscriptions page, select Resource providers under Settings.

  4. Enter sql in the filter to bring up the SQL-related extensions.

  5. Select Register, Re-register, or Unregister for the Microsoft.Sql provider, depending on your desired action.

    Modify the provider

Azure CLI

To register your subscription using the Azure CLI, run this cmdlet:

# Register the SQL resource provider to your subscription 
az provider register --namespace Microsoft.Sql

Azure PowerShell

To register your subscription using Azure PowerShell, run this cmdlet:

# Register the SQL resource provider to your subscription
Register-AzResourceProvider -ProviderNamespace Microsoft.Sql

Additional provisioning issues

If you're still experiencing provisioning issues, please open a Region access request under the support topic of SQL Database and specify the DTU or vCores you want to consume on Azure SQL Database or Azure SQL Managed Instance.

Azure Program regions

Azure Program offerings (Azure Pass, Imagine, Azure for Students, MPN, BizSpark, BizSpark Plus, Microsoft for Startups / Sponsorship Offers, Visual Studio Subscriptions / MSDN) have access to a limited set of regions.

If your subscription is part of an Azure Program offering, and you would like to request access to any of the following regions, please consider using an alternate region instead:

Australia Central, Australia Central 2, Australia SouthEast, Brazil SouthEast, Canada East, China East, China North, China North 2, France South, Germany North, Japan West, JIO India Central, JIO India West, Korea South, Norway West, South Africa West, South India, Switzerland West, UAE Central , UK West, US DoD Central, US DoD East, US Gov Arizona, US Gov Texas, West Central US, West India.

Next steps

After you submit your request, it will be reviewed. You will be contacted with an answer based on the information you provided in the form.

For more information about other Azure limits, see Azure subscription and service limits, quotas, and constraints.