-Combines massively parallel processing (MPP) with Azure storage to achieve high performance and scalability.
-SQL DW leverages a scale out architecture to distribute computational processing data across multiple nodes.
-Applications connect and issue T-SQL commands to a control node
-The control node runs the MPP engine which optimizes the queries for parallel processing
-Compute nodes store all user data in Azure storage and run the parallel queries
-Data Movement System (DMS) is a system-level internal service that moves data across the nodes as necessary. DMS is the data transport technology that ensures the right data gets to the right location.
-SQL DW separates compute from storage which enables you to scale compute independently.
Decoupling storage and compute advantages:
Independently size compute power irrespective of your storage needs
Grow and shrink compute power without moving data
Pause compute capacity while leaving data intact, so you only pay for storage
Resume compute capacity during operational hours
