Answers: <p>Follow <a href="https://docs.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases#general-purpose---serverless-compute---gen5" rel="nofollow noreferrer">this article</a></p>
  <p>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)'</p>
  <p><a href="https://i.sstatic.net/ODIaP.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/ODIaP.png" alt="enter image description here" /></a></p>
  
Answers: CC BY-SA 4.0
Answers: 2020-08-31T15:56:00.110Z
Answers: Could you please provide a relevant except from the article in the answer directly?
Answers: Bruce Becker
Answers: CC BY-SA 4.0
Answers: 2020-08-31T15:44:35.023Z
Answers: 2020-08-31T16:29:33.833Z
Answers: 2020-08-31T16:29:33.833Z
Answers: Hassan Raza
Body: <p>I'm running a serverless SQL database in azure, taking a load from some data transformed by Databricks.</p>
  <p>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.</p>
  <p>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?</p>
  
Tags: <azure><sql>
Title: How many iops do I actually get in a General Purpose SQL Database in Azure?
UserDisplayName: Hans
ThreadText: # How many iops do I actually get in a General Purpose SQL Database in Azure?
  
  (Asked by: username_0 on 2020-05-29)
  
  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?
  
  **Tags:** azure, sql
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-08-31. Score: 1
  
  Follow [this article](https://docs.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases#general-purpose---serverless-compute---gen5)
  
  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](https://i.sstatic.net/ODIaP.png)](https://i.sstatic.net/ODIaP.png)
  
  > **Comments:**
  > **username_2**: Could you please provide a relevant except from the article in the answer directly?  
  
  ---
  
  