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://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool
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.
No. It is not possible. Kindly refer below link, In the General Purpose tier, you are charged for Premium blob storage that you provision for your database or elastic pool. Storage can be configured between 5 GB and 4 TB with 1 GB increments.
https://azure.microsoft.com/en-us/pricing/details/sql-database/elastic/
Either vCore or DTU model. Max 4TB.
