John Morehouse cranks that slider to the right:
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to boost memory or I/O, you had to scale the whole instance, paying for extra CPU you might not need—and hoping the upgrade fixed the bottleneck.
It worked but wasn’t elegant and could be slow or awkward. Scaling sometimes took hours when time was of the essence.
The Next-Gen Azure SQL Managed Instance marks a major shift from the old model. It was way overdue.
The downside is that there’s still a per-CPU hard cap on IOPS and it’s low. Granted, it’s only about two orders of magnitude lower than what I’d expect from a decent on-premises solution, but that’s still enough to limit severely my ability to recommend SQL Managed Instance to anybody.