Azure mi and azure database maximum size

Question

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

Answer 1

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

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 or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer.

Answer 2

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

;-)