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

Kyle Jung 0 Reputation points
2023-05-08T22:25:33.21+00:00

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.

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. Rahul Randive 9,176 Reputation points Microsoft Employee
    2023-05-08T23:03:03.2933333+00:00

    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!

    0 comments No comments

  2. GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
    2023-05-08T23:06:23.1966667+00:00

    @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

    0 comments No comments