Two years after this post, and my simple managed instance creation has been going on for almost 9 hours now. It's still creating the virtual cluster (step 2/3).
Can we reduce SQL managed Instance creation time??
SQL managed instance while creating it is showing like, it can take up to 6 hours.
is there any idea to reduce it's creation time?
3 answers
Sort by: Most helpful
-
-
Sreeju Nair 12,621 Reputation points
2022-01-05T11:23:08.693+00:00 You can find the management operations and corresponding estimated duration from the below link.
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/management-operations-overview
-
GeethaThatipatri-MSFT 29,517 Reputation points Microsoft Employee
2022-01-05T20:16:14.447+00:00 Hi, @Vinay Hegde Welcome to Microsoft Q&A Thanks for posting your question.
Thanks, @Sreeju Nair for your contribution.
In addition to sreejukg, The 6h part is probably an outdated notice in the portal but it's still around 4h these days when a virtual cluster needs to be created.
See all the details here With instance pools you can get a new instance in way less time but that's mostly due to the fact that you already "pre-provisioned" and are paying for that compute https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-pools-overviewRegards
Geetha