Azure SQL Database vs. Azure SQL Database Warehouse

 

Size

Max of 1 TB for a database

No limit

Concurrent Queries

Up to 6,400

Up to 32

Active Connections

Up to 32,000

Up to 1,024

Cross-database Queries

Supported

Not supported

Pause/Resume

Not supported

On-demand pause/resume of resources

Scalability

11 tiers

12 options that can be managed by sliding a bar up and down

Replication

Supported through secondary databases
in different regions (up to 4)

Not supported

In-Memory OLTP Tables

Supported

Not supported

Polybase

Not supported

Supported

Processing

OLTP
(Online Transaction Processing)

OLAP
(Online Analytical Processing)

More Information

On Microsoft Azure SQL Data Warehouse

More on

Azure