SQL question

Question

Hi
I have a student that have problems with the SQL part.
He's database is very small. (Below the free 250 Gb.) - but now he's disabled in Azure.
And the price for he's database is a lot bigger than it should be, as far as he, and I, can figure out.

I would so much like to help him.

Brgds.
Jorgen Schnedler
Ingineer at DTU
Ballerup
Denmark

Answer 1

Hi @Jørgen Schnedler , welcome to Microsoft Q&A forum.

As you mentioned about Azure SQL database getting disabled, we can check through below options about the reasons behind it:

1). We can check activity logs under Monitor to understand if there is any error that is disabling the database. Also we can click on 'Quick Insights' there to check the logs for specific settings as mentioned in below screenshot:
https://learn.microsoft.com/en-us/azure/azure-resource-manager/management/view-activity-logs

2). Also we can go to 'Help + Support' and check the service health from there as well.

For the other query related to price, I would suggest you to check the below link and provide the configuration used, it will tell the price that should be applicable. Just select Azure SQL database here.
https://azure.microsoft.com/en-in/pricing/calculator/

Please let me know if this helps or else we can discuss further on the same.

----------

If answer helps, please select 'Accept Answer' as this could help other community members looking for similar queries.