What is the limit on the number of logical servers (SQL) per subscription?

Question

I have found conflicting information:

From https://learn.microsoft.com/en-us/azure/azure-sql/database/logical-servers?view=azuresql&tabs=portal#overview I see 6

Is restricted by a quota within the parent subscription (six servers per subscription by default, for more information, refer to subscription limits)

And from https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-logical-server?view=azuresql#logical-server-limits I see 250

The second source seems more official, but still...

Answer 1

250 is correct, and here’s why

The default limit for the number of logical SQL servers per subscription in a region is 250. This is both the default and the maximum limit, as specified in the Azure documentation below.

https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-logical-server?view=azuresql

If your subscription requires more than the default limit of 250 logical SQL servers per region, you can request an increase in the limit by submitting a Quota Increase Request to Azure Support.

Here’s how you can submit a request to increase the limit:

Steps to Request a Quota Increase:

1. Go to the Azure Portal: Navigate to Azure Portal.
2. Go to the 'Subscription': In the left-hand navigation pane, click on Subscriptions and select your subscription.
3. Check Usage + Quotas:
   • In your subscription, select Usage + Quotas.
     • Search for SQL logical server quotas to check your current usage and the set limit.
4. Request a Quota Increase:

• In the Usage + Quotas section, find the SQL server quota limit.
• Click Request Increase or submit a New Support Request.

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards

Answer 2

@Carl Létourneau Thank you for reaching out.

In addition, to the above answer.

The limit on the number of logical servers (also known as SQL servers) per subscription in Azure SQL Database depends on the subscription type.

https://learn.microsoft.com/en-us/azure/azure-sql/database/logical-servers?view=azuresql&tabs=portal

Answer above from Rajeswari Depala looks correct to me. Please don't forget to mark as accept answer as this will be useful for other community members with, the same question.

Regards,

Oury