Azure mi and azure database maximum size

Anshal 1,826 Reputation points
2022-08-31T14:59:35.48+00:00

Hi friends azure databases mi and azure SQL database size estimate is confusing I read the doc which iam getting more confuse and understand that storage is upto 2tb and hypersacle is 100tb but if my database is more than 10gb and still want to go to azure mi then what solution I can do

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 27,002 Reputation points Microsoft Employee
    2022-08-31T15:40:04.977+00:00

    Hi, @Anshal Thank you for posting your question on Microsoft Q&A and for using Azure services.
    For SQL MI we can go up to 16 TB..
    the piece you need to watch out for closely is the required core count - this is also dependent on the tier
    For example, to get the 16 TB max in the BC tier you need the memory-optimized hardware (still in preview) and the maximum number of vCores please check this document here

    Under the service tier characteristics, there is a chart. Take a look at the max instance storage size
    236604-image.png
    if you are planning to go with the GP tier, you need a minimum of 16 vCores
    if BC tier, for 10 TB you need memory-optimized and 64 vCores (which is a bit expensive)

    please let me know if you need any additional information.

    Regards
    Geetha

    Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Bjoern Peters 8,776 Reputation points
    2022-08-31T15:27:28.95+00:00

    Maybe you got something mixed up...

    MI is up to 2 Terabyte
    Hyperscale is up to 100 Terabyte

    you are talking about 10 Gigabyte

    10GB are 0.01 TB

    ;-)