Blog Post

Azure Synapse Analytics Blog
5 MIN READ

Understand Synapse dedicated SQL pool (formerly SQL DW) and Serverless SQL pool

Liliam_C_Leme's avatar
Liliam_C_Leme
Icon for Microsoft rankMicrosoft
Sep 13, 2022
Two recurring questions I frequently get from customers are: "What is the difference between Synapse dedicated SQL pool (formerly SQL DW) and Serverless SQL pool?" and "Which one should I choose for ...
Updated Sep 09, 2022
Version 1.0
Synapse SQL
versydney's avatar
versydney
Iron Contributor
Sep 13, 2022

Thanks for this, really helpful guide. Although I think it fails to advise what general use cases are targeting dedicated vs serverless. I know it depends on the organisation but in general, something like "serverless SQL pools are for adhoc querying while dedicated is for data warehousing" would be great.