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

CC BY-SA 4.0
2020-08-31T15:56:00.110Z
Could you please provide a relevant except from the article in the answer directly?
Bruce Becker
CC BY-SA 4.0
2020-08-31T15:44:35.023Z
2020-08-31T16:29:33.833Z
2020-08-31T16:29:33.833Z
Hassan Raza
<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>

<azure><sql>
How many iops do I actually get in a General Purpose SQL Database in Azure?
Hans
# 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?  

---

