Search code examples
azureazure-synapse

How do I calculate the cost of Azure Synapse Analytics?

I need to calculate the cost of the Azure Synapse Analytics. I have used the Azure Pricing Calculator but I could not figure it out. It shows close to USD 2,100.

enter image description here

I have the following components as a part of the Azure Synapse Analytics

  1. Synapse workspace
  2. Self Hosted agent - Standard_B2s
  3. Synapse SQL pool

How do I calculate the cost of Azure Synapse Analytics?

Solution

  • Here is a sample pricing calculator filled out to describe your situation. The assumptions are below.

    • you are using a Dedicated SQL pool not a Serverless SQL pool
    • you have scaled the dedicated SQL pool to DWU100c and left it running 24 hours a day (if you programmatically pause it then that would reduce the cost)
    • you do not want to commit to running it 24 hours a day for 1 or 3 years and get reserved pricing discounts
    • in the dedicated SQL pool you have under 1TB of data (compressed) and you have geo-redundant backups enabled
    • you are running under 1,000 pipeline activities per month on the self-hosted integration runtime, copy activities run less than an hour per month, and other activity hours are less than 7 hours per month.
    • you are not using other parts of Synapse like Spark pools, data flows, Data Explorer pools, Synapse Serverless SQL, etc.
    • you are in the East US Azure region
    • you have a B2s virtual machine with a 128GB premium SSD OS disk and no other attached disks where the self-hosted IR is installed. It is running 24 hours a day. (The VM cost but not storage cost could be lowered if you pause and resume it programmatically)
    • on the B2s virtual machine you do not want to commit to running it 24 hours a day for 1 or 3 years to get a reserved pricing discount and you are renting the Windows license with the VM rather than bringing your license with Azure Hybrid Benefit
    • this is retail pricing