Azure Managed Instance General Purpose vs Business Critical tier switching back and forth

Gokhan Varol 111 Reputation points
2020-11-18T04:01:09.933+00:00

Can we easily switch between Azure Managed Instance General Purpose vs Business Critical tier. (if we have around 4TB data how long will it take or will it not even affect the current running processes, will it require downtime, if we switch from General Purpose to Business Critical then later can we move back to General Purpose)
We are currently in General Purpose tier having performance (mainly IO related problems), we wanted to test if Business Critical tier would fix the issues.
As I understand the max server data size in Business Critical is 4TB and General Purpose Tier is 8TB (which could be an issue for us)

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,351 Reputation points
    2020-11-18T07:17:06.013+00:00

    @Gokhan Varol Welcome to Microsoft Q&A forums and thank you for your interest in Azure services.

    The time taken for scaling will vary depending on the configuration and volume of data.
    For scaling General Purpose to Business Critical and vice versa, 90% of operations finish in 2.5 hours + time to seed all databases at 220 GB/hour.

    These scenarios are documented in detail here

    The database is online and available during the scaling operation but there is a short downtime up to 10 seconds because of the failover to the new instance. You can add a retry logic to your application to handle this scenario.

    More details are here

    Please let us know if you have any further questions.

    ----------

    If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

    1 person found this answer helpful.
    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.