Deployment of Azure SQL Managed Instance stuck in Step 3 - New Instance Startup

Johannes Maly 101

Yesterday I started to create a SQL Managed Instance (Creation date: 2025-02-04 11:31 (UTC)).

I tried to create the SQL-MI in West Europe as General Purpose Standard-series (Gen 5) (4 vCores, 300 IOPS, 64 GB storage, Locally-redundant backup storage).

Deployment startet and no error was reported but since several hours the process got stuck:

Creating managed instance

Requested parameters

GP / Standard-series (Gen 5) / 4vCores / 64GB

Step 3/3: New SQL Instance Startup

In Progress

I also tried to create a SQL-MI a few days before with the same result - stuck in step 3:

User's image

A colleague of mine from another company also tried it and got the same result. Step 3 got stuck. Creation of SQL-MI was running for more than 22 hours before he canceled the deployment.

No errors were reported so far. As far as I heard a normal deployment would take between one up to four hours.

Does anybody know how to locate the huge delay in SQL-MI creation?

BR Johannes

2 answers

Mahesh Kurva 2,920 Reputation points Microsoft External Staff

2025-02-05T13:27:14.45+00:00
Hi @Johannes Maly,

Welcome to Microsoft Q&A forum.

As I understand, you're facing an issue with your SQL Managed Instance (SQL-MI) creation process being stuck for so long.

We have reproduced your issue, but we were able to successfully create the SQL Managed Instance with your specifications.

If you're using the Azure portal, try using Azure CLI or PowerShell instead.

If you're facing issues in the West Europe region, try deploying in a different region.

Ensure that your subscription and region have sufficient resources available for the deployment. Sometimes, resource constraints can cause delays.

Sometimes, deployments get stuck due to temporary issues that can be fixed by retrying.

For more information, please refer the document: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-create-quickstart?view=azuresql&tabs=azure-portal

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.
Johannes Maly 101 Reputation points

2025-02-05T15:27:59.31+00:00

Thx for your quick reply. Anyhow ... the creation of the SQL-MI is still stuck in step 3. No errors popped up. Just in case the is a problem with insufficient resources available in my subscription I would at least expect a note or error message.

It is really impossible for me to find out why the deployment got stuck.

Mahesh Kurva 2,920 Reputation points Microsoft External Staff

2025-02-05T18:25:22.97+00:00

Hi @Johannes Maly,

Apologies for causing the issue.

Here are a few additional steps you can take to try and resolve the issue:

Ensure that there are sufficient resources available in your subscription and region. Sometimes, resource constraints can cause delays without explicit error messages.

Check the activity logs in the Azure portal for any hidden warnings or errors that might provide more insight into why the deployment is stuck. You can find the activity logs under the "Monitor" section.

If you haven't already, try using an ARM template to deploy the SQL Managed Instance. This can sometimes provide more detailed error messages and better control over the deployment process.

Cancel the current deployment and retry. Sometimes, transient issues can cause delays, and a fresh attempt might succeed.

I hope this information helps. Please do let us know if you have any further queries.

Erland Sommarskog 118.9K Reputation points MVP

2025-02-05T22:33:30.2166667+00:00

My gut reaction is to try another region. If this not an option, open a support case, if you have that plan. The behaviour does not sound exactly normal.

Johannes Maly 101 Reputation points

2025-02-06T05:34:50.27+00:00

Seems it is working in Germany West Central. At least my colleague managed to got it deployed there within 13 minutes.
So I will try it to in that region and I already have created a support case.
Thank you all very much for your support.

Mahesh Kurva 2,920 Reputation points Microsoft External Staff

2025-02-06T16:53:48.1466667+00:00

Hi @Johannes Maly,

Thanks for the response. Could you please reply on the forum with the solution you received from the support case? This will be beneficial for other customers facing a similar issue.

Thank you.

Johannes Maly 101 Reputation points

2025-02-06T17:06:18.82+00:00

Even MS support ticket couldn't help in clarifying the cause of the extreme delay in SQL-MI deployment.

For me it definitely seems to be a problem region West Europe. But MS support couldn't up to now explain this strange behaviour.

Thank you all for your help

Mahesh Kurva 2,920 Reputation points Microsoft External Staff

2025-02-07T10:23:16.47+00:00

Hi @Johannes Maly,

We have received your feedback concerning the response provided on the thread, indicating that it was not helpful. I genuinely appreciate your input and aim to understand how we can enhance our responses to better meet your needs.

Could you kindly share more details on what we could have improved? Your insights are invaluable to us as we strive to elevate your engagement experience and provide the best support possible. I have included a detailed answer with clear steps for your query. If you find it helpful, you may consider re-evaluating the engagement you received on the thread. Your feedback is crucial for our continuous improvement. Additionally, as you have opened a support ticket, could you please reference the ticket number in your response? This will assist us in tracking the progress of your request and ensuring you receive the most efficient support possible.

I look forward to your reply and greatly appreciate your feedback.

Johannes Maly 101 Reputation points

2025-02-10T08:43:17.8266667+00:00

Case 2502050050002677

The thing with the response is not that it was wrong. But it was not helpfull in finding the reason for that strange behaviour. And I prefer to find the problem first before trying different things. As long as there is no error nor message provided by the deployment process it is impossible for me to see what was causing that very huge delay.

BR Johannes

Mahesh Kurva 2,920 Reputation points Microsoft External Staff

2025-02-10T09:39:27.2766667+00:00

Hi @Johannes Maly,

Thank you for providing the service request number.

We are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update.

Johannes Maly 101 Reputation points

2025-02-10T17:33:39.23+00:00

Perfect

Thx

Mahesh Kurva 2,920 Reputation points Microsoft External Staff

2025-02-24T08:43:14.9566667+00:00

Hi Johannes Maly,

I received an update from the internal team that you are going to re-test the scenario. Did you get a chance to redeploy a new SQL-MI in the West Europe region?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Johannes Maly 101 Reputation points

2025-03-05T16:19:05.5+00:00

According to MS support:

"Due to the maximum capacity over the region it has been stuck for such long time"

I retried to deploy another SQL MI to region West Europe. This time it worked but the deployment took more than one day.

Today I also tried to reconfigure the update policy for SQL MI. Even this process

takes a very very long time and has not finshed yet after several hours.

Anyhow ... SQL MI deployment to West Europe seems to work. Even though you have to be VERY patient.

Thanks to all for your support

Johannes
Please sign in to rate this answer.
Mahesh Kurva 2,920 Reputation points Microsoft External Staff

2025-03-05T16:52:39.45+00:00

Hi Johannes Maly,

I'm glad to know that your issue got resolved. Thanks for sharing the information here. Please continue using Microsoft Q&A platform for further queries.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Deployment of Azure SQL Managed Instance stuck in Step 3 - New Instance Startup

2 answers

Your answer