Azure pricing is quite confusing.

Wajid Ali Khilji 46 Reputation points
2022-08-28T05:52:17.877+00:00

Hey,

I have just started a sql server, which mentions the pricing as in the picture 1. I have set the database limit to minimum size to save money. However, when I check my subscription I see have been charged 11$ instead of 0.14 per month as mentioned in picture 1 and 2. Moreover, I started server-less Azure functions which are surprisingly costing me more than App service in linux. Can someone suggest how can I keep my budget under 100$ per year using App service or functions. Right now I am using Static website which is free, but it needs backend, where the azure is getting expensive for me. Please help in this regards, I will be looking forward to hearing from you.

Thanks and regards,
Wajid
235561-pic1.png

235385-pic2.png

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,008 questions
Accepted answer
  1. David Broggy 5,681 Reputation points MVP
    2022-08-28T13:47:19.053+00:00

    Hi there,

    You've done the right things to reduce your cost.

    Is there anything you can do to reduce the processing time in your app? Since you're being charged for processing time that won't go down if your application is constantly using resources.

    Another alternative would be to switch to Azure functions if there was a way to eliminate your need for using sql.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Wajid Ali Khilji 46 Reputation points
    2022-09-20T08:14:37.17+00:00

    One more recommendation is to use Azure cosmos DB then your cost will be virtually none or zero. Because Cosmos DB is free for upto infinity (I mean until you become mainstream to handle millions of transactions)

    1 person found this answer helpful.
    0 comments
  2. Wajid Ali Khilji 46 Reputation points
    2022-08-29T12:24:04.333+00:00

    The solution is to create SQL server with the DTU based purchasing model (Basic for less demanding workloads). This can give you database of upto 2 GB for 4 euros per month. And for function app, you need to create function app with F1 Free tier Service plan app. Which is usually preselected (In Azure for Students subscription), but still went into options and but could only find paid options. So now I just created the function app, with pre-selected F1 tier. Make sure to use Windows infrastructure, you will get an error in linux infrastructure for some reason. So Free static web app, and free function app with free app service plan, gets you to just 4 euros per month for the database. I hope this helps.
    Thanks.