cost comparison - serverless vs dedicated sql pool

arkiboys 8,026 Reputation points

at present we are using azure sql server to hold data, etc.

Is there a link or guidelines where I can compare the cost of synapse serverless vs dedicated sql pool vs azure sql server?

Thank you

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,636 questions
No comments
{count} votes

Accepted answer
  1. BhargavaGunnam-MSFT 9,896 Reputation points Microsoft Employee

    Hi @arkiboys ,

    In addition to Samy's answer:

    Here is an example of resources in West US:

    If your dedicated SQL pool is configured with 100 DWU and used for an hour with 2 TB data processed then the cost

    $1.51(for DWUs)+ $55.50 (for data processed) = $ 57.01

    For Serverless:

    2Tb(data processed) = $6.76


    Serverless Sql pool:


    Dedicated SQL pool:



    You can purchase reserved capacity for your Dedicated SQL pool (formerly SQL DW) resource, which is generally available today.

    and you can save up to 65 percent compared to pay-as-you-go rates with reserved capacity pricing for your data warehousing workloads running on Azure.

    I hope this helps.

1 additional answer

Sort by: Most helpful
  1. Samy Abdul 3,016 Reputation points

    Hi @arkiboys , please go through Azure Synapse Analytics pricing link, it should give a fair idea:

    , Thanks