Total Page Preview:   000000007735

Limitations of Azure SQL Database

In this article we will know Limitation of SQL derver, database, DTU, eDTU, vCore, Storage, Max Connection etc. in Azure SQL Database.

Limitation Of Azure SQL Database

Resource Limitation of Azure SQL Database


Resource Limit
Default number of servers per subscription in any region 20
Max number of servers per subscription in any region 200
Databases per server 5000
Max Compute Size : DTU/eDTU/vCore
DTU Basic = 5, Standard = 3000 and Premium = 4000
eDTU Basic = 1600, Standard = 3000 and Premium = 4000
vCore General Purpose: provisioned (Gen4 = 24, Gen5 = 80), Serverless (Gen5 = 16)
Hyperscale: (Gen4 = 24, Gen5 = 80), Serverless NA
Business Critical: (Gen4 = 24, Gen5 = 80), Serverless NA
Note:- All vCore Model Gen: 168 GB, Gen5: 408 GB and Serverless Gen5: 48 GB upto Memory.
Max Storage : DTU/eDTU/vCore
DTU Basic = 2GB, Standard/Premium = 1 TB
eDTU Basic = 156 GB, Standard/Premium = 4 TB
General Purpose/Business Critical = 4 TB
vCore General Purpose: provisioned (Gen4/Gen5 = 4 TB), Serverless (Gen5 = 48 GB)
Hyperscale: Auto Scale
Business Critical: (Gen4 = 1 TB, Gen5 = 4 TB), Serverless NA
Max concurrent sessions: DTU/eDTU/vCore
DTU Basic = 300, Standard/Premium = 30000
eDTU Basic/Standard/Premium = 30000
General Purpose/Business Critical = 30000
vCore General Purpose/Business Critical/Hyperscale: = 30000
Max concurrent workers(requests)/connection/logins: DTU/eDTU/vCore
DTU Basic = 30, Standard = 6000 and Premium = 6400
eDTU Basic = 3200, Standard = 6000Premium = 6400
General Purpose/Business Critical (Gen4 = 5040, Gen5 = 8400)
vCore General Purpose/Business Critical (Gen4 = 4800, Gen5 = 8000) General Purpose Serverless (Gen5 = 1200)


Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn :


Brijesh Kumar
यह बहुत ही उत्कृष्ट जानकारी है




Recent Posts

How to get the alternate rows or records from table in sql server
Data Warehouse Three Tier Architecture
SQL Server - Fragmentation on azure sql database
Limitations of Azure SQL Database
PIVOT and UNPIVOT in SQL Server with Example
SQL Server - Find unused indexes on azure SQL database scripts
SQL Server - Find all index with key columns on Azure SQL Database
Find Resource usage in Azure SQL Database using script or T-SQL
How to Set client IP Address using the firewall security in Azure SQL Using Portal
What are the types of User Define Function and difference between a nested UDF and recursive UDF in SQL server?
Top 60 SQL Server Interview Questions Answers for freshers and experienced
Top 16 performance query optimization techniques in SQL Database?
What is a Trigger and type of trigger in SQL server?
How many types of dimension tables available in data warehouse?
Data warehouse Interview Questions Answers for freshers and experienced
What are the differences between OLTP and OLAP?
What is Table Variable? Explain its advantages and disadvantages?
What are the different types of Error Handling in SQL Server?
Cloud Data Engineer SQL Server Interview Questions Answers for freshers and experienced
What are characteristics and advantages of stored procedure?

Facebook User: