How can i set up the block for usage for free sql?

Question

I am using free account and 1 s0 sql database, also able to see usage / limit in free service tab. How can i set up the block when they exceed the limit usage?? Only warning system there.. sorry so basically question because i am not the developer.

Answer 1

Hi Kyle Jung •

Thanks for your question.

As per this stack overflow thread, https://stackoverflow.com/questions/12787789/how-to-set-azure-max-spending-limit-or-cost-cap-amount

It's possible to create a budget inside Azure, whereby you can get an email if the costs get to e.g. 90% of your the amount you want to spend pr. month. This way you can manually shut down services inside Azure. Just go to Azue portal > Cost Management + Billing > Budget > Add > fill in relevant info.

Please check if this helps in your scenario too.

Let us know if you need any additional information.

Thank you!

Answer 2

@Kyle Jung Welcome to the Microsoft Q&A forum, Thanks for posting your question.

You can set up a block when the usage limit is exceeded, you can create an alert rule in Azure Monitor email alerts triggered to trigger when the usage limit is exceeded, and then configure an action to block further usage. You can also set up an email notification to be sent when the alert is triggered. however, If you want to avoid being charged for additional usage, you can stop the resource after usage. Stopping a resource will temporarily halt the resource and you will not be charged for the stopped resource.

Please let me know if you have any additional questions.

Regards

Geetha