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?

Bruce Becker
  • 3,783
  • 4
  • 20
  • 41
Hans
  • 111
  • 1

1 Answers1

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

Hassan Raza
  • 166
  • 4