Why is Azure SQL database so expensive?
For a small personal coding project I recently created a SQL database in Azure. For the past weeks I have been hardly using the database, out of 2 GB available space I have been using only 13 MB.
However, the database costs me 6,70 EUR per day and I don't understand why this is the case. Read a few topics/posts stating that the costs with similar use should be around 5-7 EUR per month, not per day.
This is the configuration for the database:
- No elastic pool
- General purpose, Gen5, 2 vCores
- West Europe
Does anyone have an idea about what could be causing the costs per month to be so high?
You choosed the General purpose, Gen5, 2 vCores price tier. Here is the cost every month:
This means that you must pay for it no matter how many space you used. As you said you just used only 13M. So you must change the Pricing tier.
What I suggest you is configure you database price to Bacic which only cost you 4.99 USD per month. Basic price tier provides 5 DTUs and Max size 2GB for you.
You can change the price tier on the database overview site:
Hope this helps.
- Cascading Soft Delete
- ERROR: extra data after last expected column on postgresql
- Create login and logout rows from single row
- Add parameter within SQL query - Python
- How to Count & Group SQL Results into Custom Group Categories?
- How to SQL Filter for Timestamp Differences in Toad for Oracle?
- How to convert a Calculated Time Difference to Decimals in Toad for Oracle?
- How to find entries in a Column - where an adjacent column switches value, and then reverts back to the original value?
- SQL, How to convert VARCHAR to bigint?
- How to join two tables where the entries are listed as rows in one table and as columns in the other table?
- PHP and SQL Shopping Cart is Not Adding Products to Shopping Cart
- Get mySQL MONTH() to use leading zeros?
- Select only distinct values from two tables on pgadmin without getting all combinations
- Brand name whose amount is increasing every year
- Performance loss introducing lateral join in Postgres query
- Is it possible to create a procedure with ANALYZE table instruction?
- How to merge 2 or more rows and SUM a column in an UPDATE without a primary key?
- How can I update top 100 records in SQL server?
- How can i insert/ select into a table and delete copied records from original table?
- Synapse/ ADF - How to Truncate table if dynamic config column is True in pre-copy script
- Fastest way to determine if record exists
- Unrecognized column name that I define
- SEDE Data Query to find posts that have hidden comments added by me
- What is the most efficient way to count rows in a table in SQLite?
- Renaming foreign-key columns in MySQL
- Fetch dates within the next 5 days from today, from a column of dates
- Preg split multi SQL by semicolon in PHP
- Mysql Pivot View
- Is it good practice to have a column for each user and a row for each user in SQL table?
- How to filter Select option to ALL