How many iops do I actually get in a General Purpose SQL Database in Azure? I'm running a serverless SQL database in azure, taking a load from some data transformed by Databricks.
Every time I try to write to the database the, IOPS percentage shows up as 100% which makes it clear that this is my bottleneck.
In the database configuration tab, I can see that for general purpose I get 500-20000 IOPS provisioned. But how do I actually get and can I control this in any way?
Follow this article
But in serverless mode you will have to look at limits for the vCores your DB is using at that second, so if vCores are 4 then you will have limit of 1280 and Throughput of '5-7 ms (write) and 5-10 ms (read)'