Is Azure SQL Elastic Pool the Right Choice for Having Separate SQl DB in DEV and PROD Environment
When hosting a Web app using a SQL DB in Azure, we need a separate SQL DB in DEV & PROD environments. Will using Elastic Pool be the better choice than Single database with 1 instance?
It looks like the cost for 2 databases using Elastic Pool (1 for DEV & 1 for PROD) will be the same as the cost for Single database with 1 instance. Does using Elastic Pool add more complexisty for Web App development?
Does using Elastic Pool add more complexity for Web App development?
No, Elastic Pool doesn't add complexity infect it allows you to easily manage multiple databases which share same configuration and requires unpredictable usage demand.
Will using Elastic Pool be the better choice than Single database with 1 instance?
This completely depends on your application requirement. Thought, I don't believe that your DEV environment DB required elastic pool because it's purpose only for Development which doesn't require scalability.
For PROD environment, Elastic Pool is a good option if your application has below use-cases. Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands.
Refer: Elastic pools help you manage and scale multiple databases in Azure SQL Database
- ADF Out of memory exception
- Azure DevOps pipeline is throwing a "##[error]Project file(s) matching the specified pattern were not found". when publishing my app?
- Microsoft Entra ID: Receiving Old Token Version Despite Setting accessTokenAcceptedVersion to 2
- Rule Syntax for Azure user.memberof
- (unknown) Precondition failed when trying to create MS Graph Subscription
- Azure Function App Service Bus Trigger: Process 1 message at a time
- Azure HTTP Trigger - How to extract query parameter value from input binding- cosmosDB
- Python app deployment to Azure web app from pipeline not including requirement packages
- Force Azure Function using Service Bus Queues to only process one mesage at a time
- Azure Web Role with Transient Fault Handling Block exception: The path is too long after being fully qualified
- Azure Bicep - How to create diagnostic settings for NetworkInterface of private endpoint
- Is there a way to get static ip address for Azure Data Factory
- azure key vault - lag on secret changes
- How to create connection to create - queue item - HTTP Trigger - local - Azurite - Azure Queue Storage
- Getting error "404 The specified blob does not exist" when downlading blob using Uri
- How scopes are added to token in Azure Entra ID?
- Why does my Azure Cosmos DB SQL API Container Refuse Multiple Items With Same Partition Key Value?
- Postgres on Azure kubernetes volume permission error
- Azure: Subscribing to an external MQTT Broker
- azure.storage.blob._shared.authentication.AzureSigningError: Incorrect padding - Argo workflow
- Bash variable in JMESPath query expression
- Azure Devops pipeline failing due to AZ.Accounts Module update by MSFT
- Is it possible to use email name other than "DoNotReply" in Azure Email Communication Services?
- AADSTS65001: The user or administrator has not consented to use the application with ID '<application ID>
- Access Package Endpoint doesn't seem to be working
- install docker bash script doesn't work when used as Custom Data for Azure VM
- Docker image is not updating on Azure container registry via gitlab
- Terraform - How to find Azure Kubernetes AKS vnet ID for network peering
- Using Azure DataLakeServiceClient to download a file got forbidden response after few minutes success
- Verify that Bicep can return values from Azure Key vault