Forum Discussion

SudeepSahdeva's avatar
SudeepSahdeva
Copper Contributor
Jul 06, 2026

Number of concurrent transactions supported for an Azure SQL 4 vCores

I have an Azure SQL:

Parameters

Specifications

Deployment Model

General Purpose – Serverless

SKU / Performance Tier

Standard Series

Database Size

128 GB

Max vCores

4 vCores (scalable within Serverless range)

 

How many concurrent transactions are supported for an Azure SQL db with the above specifications.

 

Thanks

1 Reply

  • Jamony's avatar
    Jamony
    MCT
    Jul 08, 2026

    Hi, there is not a single fixed "number of concurrent transactions" for an Azure SQL database based only on 4 vCores.

     

    Concurrency depends heavily on what each transaction does. A 4-vCore database can handle many small, short transactions, but only a few heavy transactions if they are doing large scans, waiting on locks, writing heavily to the log, or consuming tempdb/CPU.

     

    For sizing, I would load test with your real transaction pattern and watch CPU, data IO, log IO, waits, blocking, sessions, and worker usage. Since this is General Purpose serverless, also pay attention to min vCores, auto-pause, and cold-start behavior. The vCore count tells you the compute envelope, but the workload shape decides the practical concurrency.