Azure Elastic Database Pools, What is the Maximum Storage Capacity for a Database?

Question

What is the maximum allowed storage capacity for a database for Azure SQL Elastic pool?

We expect our database to be say 25-50 TB. Is this permitted?

I saw something on Github saying its allowed, however did not see in a Microsoft source.

https://github.com/MicrosoftDocs/azure-docs/blob/master/articles/sql-database/sql-database-single-database-scale.md#p11-and-p15-constraints-when-max-size-greater-than-1-tb

https://learn.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

Answer 1

In general, the limit is 1 TB per database on an elastic pool. More than 1 TB of storage in the Premium tier is currently available in all regions except: China East, China North, Germany Central, Germany Northeast, West Central US, US DoD regions, and US Government Central. In these regions, the storage max in the Premium tier is limited to 1 TB. For more information, please visit this documentation.

If you expect your database to grow to 25-50 TB then your best option is Hyperscale that supports up to 100 TB. Elastic pools fall very short of your needs.