SQL Elastic Pool

Question

For the SQL Server with Elastic Pool, we will pay for each Elastic Pool / SQL Server only or all DBs inside the elastic Pool / SQL Server is billable?

Example i have 1 SQL Server with 100 DTU Elastic Pool with 10 DBs then i create another 5 DBs, will the cost is same between 10 and 15 DBs?

Answer 1

Hi,

Correct, there is no per database charge. You pay for the cost of the elastic pool. Excerpt:

Important There's no per-database charge for elastic pools. You're billed for each hour a pool exists at the highest eDTU or vCores, regardless of usage or whether the pool was active for less than an hour.

https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql#what-are-sql-elastic-pools

-TP

Answer 2

Hi Handian Sudianto, Good Day,

SQL Server will be billed on the resources that you have provisioned on the Pool and not based on the number of databases on the pool. So whether you have 10 DB's or 15 DB's on the same pool the cost will be the same till the resource allocated to the pool remains unchanged. But pls note that the performance of each individual database within the pool may vary depending on the resource utilization and demand from other databses sharing the same pool.

Thank you.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have an extra question about the answer, please click "Comment".