1

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?

1 Answer 1

1

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)'

enter image description here

1
  • Could you please provide a relevant except from the article in the answer directly? Aug 31, 2020 at 15:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.