AzureSQL Paas and Elastic Pool and Database Size

grajee 351 Reputation points
2020-11-13T00:19:15.33+00:00

All,

For the Elastic Pool Size, based on the link, is "Max data size (GB) - 1.5TB" for "GP_Gen5_6" for each database size in the pool or is it max datasize for the pool.

Does this mean @ "GP_Gen5_6" , we cannot have a Elastic Pool with Max Data Size of 4TB? If it is the case, then the minimum vCPU I should be at is 24 vCPU in order to have 4TB.

Thanks,
grajee

https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases#gen5-compute-generation-part-1

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Navtej Singh Saini 4,226 Reputation points Microsoft Employee
    2020-11-17T02:27:56.787+00:00

    @grajee

    We checked the above and found you are using the resource limits for the Single Server in the documentation.

    Here is the correct document for the elastic pools resource limits. Please go through the same and let us know if you have any question.

    Thanks
    Navtej S


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.