解决 Azure SQL 数据库或 Azure SQL 托管实例的容量错误

适用于:Azure SQL 数据库Azure SQL 托管实例

本文介绍如何在部署 Azure SQL 数据库或 Azure SQL 托管实例资源时解决容量错误。

超过配额

  • 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.
  • 在缩放操作期间,你可能会看到以下错误:
    Could not perform the operation because server would exceed the allowed Database Throughput Unit quota of xx.

订阅访问权限

如果订阅尚未向 SQL 资源提供程序 (RP) 注册,则订阅可能无权在所选区域中创建服务器。

如果看到以下错误,请向 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

启用区域

如果尚未启用所选区域,则订阅可能无法在该区域创建服务器。

如果看到以下错误,请提交支持票证以启用特定区域:

  • 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

注册 SQL RP

若要部署 Azure SQL 资源,请将订阅注册到 SQL 资源提供程序 (RP)。

可使用 Azure 门户、Azure CLIAzure PowerShell 注册订阅。

若要在 Azure 门户中注册订阅,请执行以下步骤:

  1. 打开 Azure 门户,转到“所有服务”。

  2. 转到“订阅”,选择感兴趣的订阅。

  3. 在“订阅”页上,选择“设置”下的“资源提供程序”。

  4. 在筛选器中输入“sql”,以便显示与 SQL 相关的扩展。

  5. 根据所需操作,为 Microsoft.Sql 提供程序选择“注册”、“重新注册”或“取消注册”。

    Modify the provider

后续步骤

提交请求后,可查看该请求。 系统会根据你在表单中提供的信息与你联系。

有关其他 Azure 限制的详细信息,请参阅 Azure 订阅和服务限制、配额和约束