Azure Questions

Question

Hi Azure Gurus,

I primarily work on AWS but gradually learning Azure for my next project. The shift is quite overwhelming with constant comparisons between these cloud solutions. Have few Questions, if you could help me.

1) The concept of running an Azure SQL DB on a serverless mode is quite puzzling to me. How does Azure handle cold start for a DB? Does first transaction wont get affected due to DB cold start? I know there is a Premium plan mode for running serverless but will this truly help?

2) Say I choose a particular marketplace template & deployed using a custom deployment page. It deployed fine but now if I want to rollback/delete all the underlying resources that were provisioned as part of that deployment, it's cumbersome, as deleting a deployment doesnt delete underlying resources. How to take care of this?

I would greatly appreciate answers for my above queries.

Regards,

Nikhil

Answer 1

I am having a colleague answer your questions about Azure SQL DB, but i can go ahead and answer#2.

For a custom Template or a marketplace item, it should be deployed into a new Resource Group. When you need to delete the deployment, you can delete the resource group. If there are additional dependencies that need to be deleted first, an error message should guide you on what is preventing the deletion. If you are still experiencing issues, check for documentation about deletion instructions / dependencies. 

Answer 2

Hi Nikhil,

As for your first question, part of the autoresume functionality any authentication or authorization request will initiate the database. The latency on the autoresume is about 1 minute and this ensures the database is ready to handle transactions. The resume process is not instantaneous if that is what you mean. If this does not answer your question, can you provide a specific scenario you are thinking of?

Regards,

Mike