Azure Questions.

nikhil jain 21 Reputation points
2020-05-28T16:11:06.24+00:00

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 won't 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 doesn't delete underlying resources. How to take care of this?

I'd greatly appreciate answers for my above queries.

Regards,
Nikhil

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,123 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,869 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ryan Hill 25,666 Reputation points Microsoft Employee
    2020-06-05T20:38:24.167+00:00

    Sorry about that comment and delayed response @nikhijain-3003,

    For your first question, there is no "cold start" for Azure SQL DBs. Once the resources are deployed, it's considered up and running and ready to accept incoming transactions. That is across all SKUs. What you're paying for is storage and throughput, not uptime, however you may be able to save some moeny looking at the serverless comput tier.

    With regards to your second question, the easiest way to quickly remove resources in one fail swoop is the delete the resource group it's in. Going that route means you'll have to be more methodically about how you organize your resources. For example you can have myapps-rg and prototypedb-rg, where prototypedb-rg would be the group you would deploy those marketplace templates to. However, you want to keep all of your resources like myproject-rg which would contain apps, networks, database, etc, then you would have to select the resources inside the group and hit delete. Another option is making use Azure CLI or PowerShell where you can write scripts to handle deleting of specific resources.

    1 person found this answer helpful.
    0 comments