When deleting SQL Managed Instance, if there is a lot of data inside, is it natural that the deletion time will be longer?

Question

When deleting SQL Managed Instance, if there is a lot of data inside, is it natural that the deletion time will be longer?

안 남기 181

GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-12-14T00:38:56.003+00:00

Hi, @안 남기 Thanks for the ask and for using the Microsoft Q&A platform.
When you say a lot of data and is it natural that the deletion time will be longer, have you initiated deletion and it got stuck? How long it has been for you?

Regards
Geetha
안 남기 181 Reputation points

2022-12-14T00:50:19.957+00:00

There is no problem deleting the SQL management instance. I wonder if the deletion time increases when there is a large amount of data inside.

If you give me an answer, I will adopt it.

Answer accepted by question author

0 additional answers

Your answer

GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-12-14T00:38:56.003+00:00

Hi, @안 남기 Thanks for the ask and for using the Microsoft Q&A platform.
When you say a lot of data and is it natural that the deletion time will be longer, have you initiated deletion and it got stuck? How long it has been for you?

Regards
Geetha
안 남기 181 Reputation points

2022-12-14T00:50:19.957+00:00

There is no problem deleting the SQL management instance. I wonder if the deletion time increases when there is a large amount of data inside.

If you give me an answer, I will adopt it.

Answer 1

GeethaThatipatri-MSFT 29,587 Microsoft Employee Moderator

Hi, @안 남기 Deletion should complete in 1.5 hours as per documentation. There are certain documents that can provide more detailed information on why the process takes long. Normally the first MI in a subnet can take a long, but new ones should not take that long. please check here
If deletion is taking longer time/got stuck or any error please reach out here or file a support case so we can assist you.

Hope this will help. Please let us know if any further queries.

Regards
Geetha

안 남기 181 Reputation points

2022-12-14T02:53:30.123+00:00

Not the answer I want.
I ask again.

There is no problem deleting the SQL management instance. I wonder if the deletion time increases when there is a large amount of data inside.
GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-12-14T15:00:10.717+00:00

@안 남기

The operation duration is not size-of-data related unless there's a huge tail log backup to be done. See

See more information here

I hope this answer your question.
Please let me know if you still have any additional questions.

Regards
Geetha
안 남기 181 Reputation points

2022-12-14T15:51:11.043+00:00

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automated-backups-overview?view=azuresql

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/recovery-using-backups?view=azuresql&tabs=azure-portal

-->
You have verified that the amount of internal data is not related to the SQL management instance deletion time.

Determined that the amount of internal data is related to the backup and restore time of the SQL management instance.

Thank you for your help.
I'll adopt it.

Share via

When deleting SQL Managed Instance, if there is a lot of data inside, is it natural that the deletion time will be longer?

0 additional answers

Your answer