Why this DB configuration generated a costs?

Question

I use student subscription.
My DB has this configuration

I left it empty for night and in morning it generated 0.6 Euro cost.

Why?

I use it for my private project. I execute on this DB simple selects and inserts - my average of CPU use is around 0.8%.

Current cost is 1.4 euro.

How does it work?

Answer 1

I teach classes at the university, and I often suggest my students to use Azure SQL Serverless to save the most as you pay only for what you consumed instead of paying for resources reserved. After 1 hour of no activity the serverless database gets auto-paused and when you try to connect again it auto-resumed. For you to learn it is a great option.

Be aware of not letting database tools like SQL Server Management Studio, Visual Studio, Azure Data Studio connected to a Serverless database as they may prevent the database from getting into sleep.

The charges you see are related to reserved resources you have and not for the use you did of those resources. So, my suggestion is move to serverless and you should be fine, you will be charged by what you consumed, and the student credit may last longer.

If you are already using Azure SQL serverless make sure you do not use one of features in this list as they may prevent the database to getting into auto-pause mode. Do not get database tools or apps connected to the database also as their activity may also prevent the database into going to auto-pause mode.