Azure Synapse Analytics Documentation

Dedicated SQL Pools

What is a Dedicated SQL Pool?

A dedicated SQL pool (formerly SQL Data Warehouse) provides a massively parallel processing (MPP) architecture that enables you to run complex analytic queries across petabytes of data. It is fully integrated with Azure Synapse Analytics, allowing seamless data ingestion, preparation, management, and serving.

Provisioning a Dedicated SQL Pool

Use the Azure portal, Azure CLI, or PowerShell to create a new pool. Example using Azure CLI:

az synapse workspace create \
  --name MyWorkspace \
  --resource-group MyResourceGroup \
  --location eastus

az synapse sql pool create \
  --name MyDedicatedPool \
  --workspace-name MyWorkspace \
  --resource-group MyResourceGroup \
  --performance-level DW1000c

Scaling Compute

Scale compute up or down without affecting data.

Performance LevelDW UnitsMax Power
DW100c1002,500 DTUs
DW300c3007,500 DTUs
DW1000c100025,000 DTUs

Security & Compliance

  • Transparent Data Encryption (TDE)
  • Always Encrypted
  • Row‑level security
  • Integration with Azure AD authentication
  • Network isolation via Managed Private Endpoints

Monitoring & Alerts

Leverage Azure Monitor, Log Analytics, and built‑in workload insights to track performance, resource usage, and query execution.

SELECT *
FROM sys.dm_pdw_resource_stats
WHERE start_time >= DATEADD(hour, -1, GETDATE());