Generally this kind of thing is needed for all clouds, but Azure SQL has a few additional issues in some SKUs. It all stems from the decreasing “IOPS per TB” a

Generally this kind of thing is needed for all clouds, but Azure SQL has a few additional issues in some SKUs. It all stems from the decreasing “IOPS per TB” as mechanical drives get bigger. Large scale multitenant hosting uses up all available IOPS, which means it has to be carved up and meted out carefully. Years of this being the status quo set an expectation that the availability of modern SSDs hasn’t yet eliminated. Everyone is used to services with throttled throughputs of a few hundred operations per second in an era where this should be a few hundred thousand…