How to find Azure Subscription Quota

azure azure-sql-database azure-web-roles
Nil Pun picture Nil Pun · Jun 16, 2013 · Viewed 13.9k times · Source

I did google and could not find any accurate answer.

When I try to deploy the web application to different data centre, I am getting error message below:

    Server response = 40652 Cannot move or create server. 
Subscription 'xxxxxxxxxxxxx' will exceed server quota.

Could someone please help me understand below:

  1. Where do I find the max quota for given subscription within a management portal?

  2. Does error above means the quota exceeded for Azure SQL Server or Host services.

  3. How many servers can one subscription create?

I used Cerebrata cloud management studio which shows the subscription detail below:

Cores: 9 / 20
Hosted Services: 4 / 20
Storage: 8 / 20

Not sure whether Azure SQL Server belongs to hosted service or storage or something else that's not shown above.

Thanks.

Answer

user2625214 picture user2625214 · Jan 9, 2015

For Azure SQL Servers, there is a hidden default max of 6 Azure SQL SERVERS (Not databases). Once you attempt to create the 7th, you will receive this error: New-AzureSqlDatabaseServer : Cannot move or create server. Subscription 'XXXXXX-XXXX-XXXXX-XXXXX-XXXXXXXXXX' will exceed server quota. Submit a billing request to increase the quota limit on SQL Azure Servers.

Related questions

Optimal way to concatenate/aggregate strings

I'm finding a way to aggregate strings from different rows into a single row. I'm looking to do this in many different places, so having a function to facilitate this would be nice. I've tried solutions using COALESCE and FOR …

Read More
Azure SQL Database "DTU percentage" metric

With the new Azure SQL Database tier structure, it seems important to monitor your database "DTU" usage to know whether to upgrade or downgrade to another tier. When reading Azure SQL Database Service Tiers and Performance Levels, it only talks …

Read More
How to re-create database for Entity Framework?

I have got into a bad state with my ASP.Net MVC 5 project, using Code-First Entity Framework. I don't care about losing data, I just want to be able to start fresh, recreate the database and start using Code-First migrations. …

Read More