Can someone explain how sql databases are costed in azure when using an elastic pool. The Elastic Pools' service tear is "General Purpose (Most Budget friendly, serverless compute)", the hardware is set to Standard-series (Gen5). We have set the max vcores to 4 and the Data max size to 500gb. According to the estimated cost this should be around $606.75 per month however over the month of may we were charged by our third party retailer over $2200. I dont understand why there is such a difference Do we get charged for consumption ontop of the base fee?
unexpected costs when using Elastic Pools
302 Views Asked by Richard Banks At
1
There are 1 best solutions below
Related Questions in AZURE-SQL-DATABASE
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- Tools for fast aggregation
- Hoiw can i remove all ip addresses from Azure SQL Server Firewall Rules , but still login via SSMS?
- Small percentage of parameters cause very slow queries
- Azure Functions v4 in Private vNet Cannot Connect to Azure Sql
- Does bcp utility support Token based Authentication? If yes, I would like to know the process and which version of bcp to be used
- "Error: Could Not create constraint or index. see previous errors" with nest js and AzureSql
- Recreating an existing edmx in Visual Studio Code for Azure Function
- How to use parameter in Azure sql_input with LIKE SQL command
- How to Process a CSV File from Power Apps/Automate into SQL Server
- Unable to connect to Azure SQL from Azure Data Factory
- Table gets promoted with no data to Prod for Azure SQL database through Azure DevOps
- System Assigned identity failed to connect to SQL Server database
- Optimal approach in accessing datalake container with multiple teams?
- Azure SQL support for Delta tables
Related Questions in AZURE-ELASTICPOOL
- Optimizing Azure SQL Elastic Pools with high memory but low CPU
- Moving data from Azure SQL to shards using elastic query
- Elastic pool storage utilization percent not decreasing
- How to move Azure Elastic Pool between different SQL Servers
- unexpected costs when using Elastic Pools
- How to set the maintenance window for elastic pool in Bicep script?
- Azure terraform add database to elastic pool
- Azure Data Factory - Scale elasticpool with web activity
- I need to clone an Azure SQL Database, which will take it past the SQL Pool Max Data Size - will it automatically increase?
- Delete database shard mapping and shard databases in SQL Server to clean up tenant resources
- Azure Single Database vs Elastic Pool Databases
- How do I create a database in an elastic pool using bicep?
- Azure Elastic Pool eDTU and Storage per DB / Pool?
- Is it possible to change Azure Elastic Pool server version
- List all databases by elastic pool using T-Sql in Azure Sql
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
With elastic pools you are 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. The cost of an elastic pool depends on the number of databases and the performance level of the pool. To get a more realistic estimation than the Azure Elastic Pool pricing calculator, try to scale the number of cores of the pool and there you will see a more realistic pricing considering the number and size of databases on the pool. See the estimated price on the image.
As you can see on the image there are added costs for storage. The price of storage for an elastic pool is the max data size specified, multiplied by the storage unit price of the service tier.
Every time you scale up the number of cores on the pool the consumption per hour increases. I had a customer that manually increased the number of vcores at 1 pm each day to 32 vcores at a cost of USD$8.00 per hour to deal with increased demand and bad T-SQL programming, at the end of the month he was paying USD$2,000 - $2,500. Maybe that is happening on your scenario.