Introducing Simplified Subscription Limits for SQL Database and Synapse Analytics Dedicated SQL Pool

We are introducing new and simplified subscription limits for Azure SQL Database and Azure Synapse Analytics Dedicated SQL Pool (formerly SQL DW). These updates are designed to reduce customer confusion and improve the overall quota management experience.

What's changing?

[ATTACH type=full" alt="raj_tiwari_3-1724655785839.png]63872[/ATTACH]

New vCore based limits: The new limits will be based on vCores per Subscription per Region, which will be directly equivalent to DTU and DWU.

Default logical servers limit: All new and existing subscriptions will now be subject to a maximum default limit of 250 logical servers. The previous limits on Logical Server DTUs have been discontinued.

Configurable vCore limits: Customers now have the convenience of easily changing their subscription limits via the support section of the Azure Portal, with approvals often processed within minutes.

New portal experience:

Below is an example of the new portal experience where customers can view their existing limits and current vCore usage and have the option to request higher limits.

[ATTACH type=full" alt="raj_tiwari_4-1724656303849.png]63873[/ATTACH]

Existing limits: Subscriptions that were previously approved for limits beyond the old system's default settings will be seamlessly transitioned to the new system without any changes to their approved limits.

Frequently asked questions

What happens to my current quota limits?

All subscriptions will have a default and maximum of 250 logical servers. For customers with previously approved quotas, the limits will be carried over to the new system.

Do quotas apply equally to my serverless DBs?

Yes. Currently, quotas are determined by overall usage, meaning that serverless usage is considered in the same manner as provisioned usage.

Is there a way to get notified before I hit my quota limit?

Not at this time. However, as a workaround you can leverage the Subscription Usages API with the usageName parameter set to "RegionalVCoreQuotaForSQLDBAndDW".

What about Dedicated SQL Pool limits in Azure Synapse Analytics?

Synapse Analytics will show limits in DWU, converted from vCores, similar to how DTU to DWU conversions are handled.

For additional details, please visit aka.ms/sqlcapacity

Continue reading...