Azure SQL Databases very slow to deploy?

Peter Rush 41 Reputation points
2022-07-19T14:20:06.21+00:00

I am regularly deploying and destroying Azure SQL Databases as part of a BI ETL solution.

Deploying a SQL Database regularly takes more than an hour; here is an example of one still going after 100+ minutes:
222318-image.png

Region is UK South - I dont know if this makes any difference (I know it's hot here today!).

Does anyone know the cause of this? I am using ARM templates to deploy the Databases, with the Powershell New-AzResourceGroupDeployment command. Any help much appreciated
Thanks
Peter

Azure SQL Database
{count} vote

2 answers

Sort by: Most helpful
  1. George Chrysovalantis Grammatikos 531 Reputation points MVP Volunteer Moderator
    2022-07-19T14:35:43.893+00:00

    Hi,

    The Azure SQL Database service status in the UK South region looks to be healthy.
    I recommend refreshing the page in your browser if you haven't done this yet.
    If the deployment failed, you can post the error message here, and I will help you with this.


  2. darjow 0 Reputation points
    2024-02-13T13:34:33.54+00:00

    I notice having this issue quite often as well.

    When destroying our full infrastructure, and running our IaC pipelines to recreate our full environment. It takes 1hour+ to just add a SQL database to the SQL server. (Knowing we have 10+ databases ... )

    What is the cause for it to take this long?

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.