Increase limit of 50 databases per Premium Elastic Pool
The limit of 50 databases per premium pool might be fine if you have large databases, but for our use cases we have relatively small databases and many of them. This means we hit the 50 database limit quite quickly. We need brief periods of high performance for our databases so the Standard pools aren't sufficient.
Thanks for your feedback here. We are evaluating increasing limits such as this in elastic database pools.
any database limit is stupid. we pay for disk space anyway, and the io is capped per processor. and to add insult, the only available option is Gen5 which doubles the cost while keeping the database limits. no reason to double the minimum number of vcores in gen5 vs gen4 (4 vs 2 thus the double cost).
John Mayfair commented
its 4 years later.... crickets.....
50 databases limit is so crazy low. Now that the GEN4 is no longer available, the LOWEST cost has DOUBLED. The pricing information does NOT mention this either. You have to dig for the max # of databases.
Are you still evaluating this? This is coming up to being 3 years old...!
Thomas Mueller commented
We have the same issue. It seems odd that basic and standard pools with 100 eDTUs support 200 databases, but premium pools with 125 eDTUs max out at 50 databases. Shouldn't higher pricing tiers have higher (or at least the same) limits?
Would also be very interested in this for the same use case, many small DB's a couple times of week we need more than DTU's than the Standard tier provides
This change would be welcomed. Thank you.