Azure Capacity Specifications - numbers to watch out for

Update (19/Mar/15): There is now official documentation on Azure Subscription and Service Limits, Quotas, and Constraints which lists the most common Microsoft Azure limits and makes the content below redundant.

SQL Server continues to have an article titled Maximum Capacity Specifications for SQL Server for each new version that comes out. It has a handy reference of the maximum sizes and numbers of various objects defined in SQL Server components. I wish there was one for various Azure Services and as I did not find one, I plan to compile a list of numbers that you should be aware of to avoid hitting the limits:

Azure Storage
Maximum Storage accounts per Azure subscription 50
Maximum size of a Storage account 500 TB
Maximum number of containers in a storage account unlimited
Maximum size of files that a Block Blob can hold 200 GB
Maximum size of files that a Page Blob can hold 1TB
Maximum number of Tables in a Storage account unlimited
Maximum number of key/value pairs that can be stored in each Table entity 252
Maximum number of messages that can be stored in a Queue unlimited
Maximum size of a Queue message 64 KB
Azure Websites
Maximum number of instances permissable with auto-scaling a Standard website 10
Azure SQL Database
Maximum Database Size of Basic Service Tier 2 GB
Maximum Database Size of Standard Service Tier 250 GB
Maximum Database Size of Premium Service Tier 500 GB
Default limit of logical Azure SQL Database servers per subscription 6
Maximum databases a Azure SQL Database server can host 150
Point in Time Restore timeframe 7 days for Basic, 15 days for Standard & 35 days for Premium
Database connectivity SLA for Basic, Standard, and Premium tiers 99.99%

work in progress...

Update (3/March/15) - Just found out that as far back as April 2014, a bunch of folks compiled list of Azure facts & figures on Github

Also see: Domain names used by Microsoft Azure services

Comments