Azure database | Azure Database is inaccessible and in halt state
Syed Sabih Haider
MCT | Solution Specialist Modern Workplace @ Hitachi Energy | Leading fight against cybercrime and trying to make a digital world more secure and accessible
Problem Statement
We are having problem in accessing our SQL Database in Azure. We are having a lot of inappropriate updates during specific load that actually ended up to stop our services. We were able to access the database and send queries but now we are unable to query the system catalog. We tried a lot to kill all the sessions which were running, but unfortunately no luck for us to resolve this thing. The next thing we tried was to re-scale the full instance but again it was not good for us, so we decided to cancel the request of re-scaling.
Then we have gone through the logs part to see the inner issue, the activity logs told us that it is forced the portal on the database page still going on/ running. Then we tried to restore our databases from the point but unfortunately it hanged up. So, we are just stuck in the middle where no connections no feedback are allowed.
Solution statement
If you are having such situation, you can try the following thing to resolve this issue
If you don’t have allowed a connection, then try to re-scale the database means scale up and down the database. This will revert all awaiting connections / transactions and will kill server level logins with connections.
Scale up and down the database may takes some time like some minutes to complete so just relax and see the status. Time will depend how your database was at the time of scale up and down operation was initiated.
Azure Database scaling information
Azure SQL Database is a flexible Platform as a service database that can be easily scaled to fit your needs. You can add more compute or storage to satisfy your performance requirements without waiting for new hardware or migrating data to more powerful machines. Azure enables you to change performance characteristics of your database on the fly and assign more resources when needed or release the resources when they are not needed in order to decrease the cost.
Azure SQL Database supports two types of scaling:
- Vertical scaling where you can scale up or down the database by adding more compute power.
- Horizontal scaling where you can add more databases and to shard your data into multiple database nodes.
For more detail click here, Thanks for reading this article !!! Keep happy Keep Learning