Azure Synapse Dedicated SQL Pool

Dedicated SQL pool (formerly SQL DW) represents a collection of analytic resources that are provisioned when using Synapse SQL. The size of a dedicated SQL pool (formerly SQL DW) is determined by Data Warehousing Units (DWU).

Note. Azure SQL DW is Massively Parallel Processing (MPP) version of SQL Server APS/PDW in Azure.

Once your dedicated SQL pool is created, you can import big data with simple PolyBase T-SQL queries, and then use the power of the distributed query engine to run high-performance analytics. As you integrate and analyze the data, dedicated SQL pool (formerly SQL DW) will become the single version of truth your business can count on for faster and more robust insights.

sql-dw

Azure SQL DW consists of Control Node with MPP engine and Data Movement Service (DMS), multiple Compute Nodes (managed by number of DW units – DWUs), and blob storage (WASB).

Note. Currently there are two versions of Dedicated SQL Pool: Stand alone and component of Azure Synapse.

Dedicated SQL pool (formerly SQL DW) in relation to Azure Synapse

Additional information:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: