Has anyone used Azure SQL MI on the next-gen general purpose tier, Microsoft documentation says it offers better IOPS compared to the regular tier.
If the IOPS limit is stated as 10k, is this limit applied per database or is it the upper limit for the entire SQL Managed Instance?
Does the IOPS we get proportionally increase the throughput limit? For some processes, throughput can be a bottleneck, but the documentation doesn't provide any details about it.