Azure SQL Server
- Database size limit is 4TB
- Optimized for OLTP loads
- Cross-database queries are supported
- Automatic performance tuning of a database is supported
Azure Data Warehouse
- Supports up to 1 Peta Byte (1024 TB) size.
- Optimized for OLAP loads
- MPP (Massively Parallel Processing) system (data is processed on multiple parallel nodes)
- Polybase support to load data from multiple systems.
- Cross-database queries are not supported.
- Manual performance tuning.
- You can pause and resume the database to reduce cost.
No comments:
Post a Comment