3 ms·

It seems crazy to me that you need to solve such infrastructure concerns at the application level. I'm really interested how this works in a large scale applica

It seems crazy to me that you need to solve such infrastructure concerns at the application level. I'm really interested how this works in a large scale application. Are retries sprinkled throughout the code base? Especially for database stuff, as EF Core doesn't support transactions when retries are enabled. I bet these resiliency issues and the fact you need to modify your application didn't make it into the cloud sales talk. I also don't see many resources mentioning it. Is this also mainly an Azure problem or does it also happen on AWS?

jiggawatts 4y ago
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…