ElasticPoolSkuCombinationInvalid - How to find a valid database SKU for different elasticpool SKU's

Question

I am getting a below error when trying to create a database with S3 for a elasticpool with StandardPool sku, I have tried different combination as per terraform document and azure document ended up with same error.
Database Name: performing CreateOrUpdate: unexpected status 400 (400 Bad Request) with error: ElasticPoolSkuCombinationInvalid: Elastic pool and sku 'S3' combination is invalid.

Is there a proper documentation in azure says how to find proper a valid combination of the database sku's with elasticpool sku.

Thanks,

Gnanasoundari

Answer 1

@Gnanasoundari
Thank you for the question and for using Microsoft Q&A platform.

As per my understanding you are trying to create a database with S3 for an elastic pool with Standard Pool SKU.

It sounds like you're encountering an issue with the compatibility between the database SKU and the elastic pool SKU. The error you're encountering is because the database SKU S3 you're trying to provision is not compatible with the SKU of the Elastic Pool you have selected. Azure SQL databases have specific requirements for valid combinations of database SKUs and Elastic Pool SKUs.

Elastic Pools have different service tiers and SKUs. Each tier has its supported database SKUs.DTU-based elastic pools: These use fixed DTU SKUs like Basic (B), Standard (S1, S2, S3), and Premium (P1, P2, P3).

vCore-based elastic pools: These use General Purpose and Business Critical tiers.

Ensure the database SKU aligns with the tier and configuration of your Elastic Pool.

You can refer to the below links for more help:
https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql
https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-manage?view=azuresql
https://learn.microsoft.com/en-us/rest/api/sql/elastic-pools/create-or-update?view=rest-sql-2021-11-01&tabs=HTTP
https://stackoverflow.com/questions/65672320/sql-database-elastic-pool-and-sku-combination-is-invalid

You can also use the Azure CLI to list the available SKUs for your region and subscription:

az sql elastic-pool list-editions -l <location> -o table

https://learn.microsoft.com/en-us/cli/azure/sql/elastic-pool?view=azure-cli-latest#az-sql-elastic-pool-list-editions
This command will help you determine the SKUs that are available and compatible with your elastic pool.

Hope this helps. Do let us know if you have any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.