Share via

Minimizing Azure SQL Database Cost

Onur 115 Reputation points
2023-12-31T23:08:42.2633333+00:00

My app is in developement stage and not used. I have minimize other resources(1 cent/day), but database(12 cent/day) consume too much for not using. How can I minimize it ?

Azure SQL Database
0 comments
Accepted answer
  1. rbrundritt 20,921 Reputation points Microsoft Employee Moderator
    2023-12-31T23:33:15.6166667+00:00

    At 12 cents a day, I guess you are looking at the Azure Basic SQL Database instance which would be the cheapest SQL instance available. You won't get SQL any cheaper than that. I took at look at Azure PostgreSQL and MySQL and I don't think that would be any cheaper.

    Since you are looking at "Basic" storage, I will assume this isn't a business-critical app, or you have some flexibility in terms of response times. With that in mind, a cheaper option would be to use Azure Table Storage. I believe Basic Azure SQL database has 2GB of storage. 2GB of table storage would cost around 13 cents a month (~0.0044 cents a day). My team has used table storage as a low-cost simple database for apps in the past. If you have a single table of data, then this is easy. If you have multiple tables and want to do table join queries, then it gets a bit trickier and requires making multiple requests and manually joining the data.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. TP 125.9K Reputation points Volunteer Moderator
    2023-12-31T23:38:47.0866667+00:00

    Hi Onur,

    Have you considered using Azure SQL Database Free Tier? You get 100,000 vCore seconds each month and up to 32GB storage free.

    Try Azure SQL Database for free (preview)

    https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer

    I don't know of a way to switch existing database to free tier, so you may need to create a new one and once you have it all set up, delete your old one.

    Please click Accept Answer and upvote if the above was helpful.

    Thanks.

    -TP

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.