cost comparison - serverless vs dedicated sql pool

arkiboys 9,621 Reputation points
2022-09-03T06:20:34.033+00:00

Hello,
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.
9,532 questions
0 comments No comments
{count} vote

Accepted answer
  1. BhargavaGunnam-MSFT 26,136 Reputation points Microsoft Employee
    2022-09-03T22:29:50.567+00:00

    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

    237499-image.png

    Serverless Sql pool:

    237561-image.png

    Dedicated SQL pool:

    237514-image.png

    237537-image.png

    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 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Samy Abdul 3,366 Reputation points
    2022-09-03T07:14:13.523+00:00

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

    ,
    https://azure.microsoft.com/en-in/pricing/details/synapse-analytics/ Thanks

    0 comments No comments