Share via

Cost of SQL server to Synapse Dedicated SQL Pool copy pipeline

Wajih Arfaoui 70 Reputation points
2024-02-02T11:28:33.66+00:00

Hello everyone, I have created a Copy activity on ADF that copies tables from SQL Server to Azure Synapse. The volume of the tables copied is around 150 GB. I was struggling with estimating the cost of it using the Azure calculator. Can you guide me through it? Thank you

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,696 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
0 comments
Accepted answer
  1. Smaran Thoomu 12,620 Reputation points Microsoft Vendor
    2024-02-05T07:05:04.8233333+00:00

    Hi @Wajih Arfaoui ,

    Welcome to Microsoft Q&A platform and thanks for posting your question.

    To estimate the cost of copying tables from SQL server to Azure synapse using ADF, you can use the Azure Pricing calculator and it's essential to understand the specific parameters involved to get an accurate estimate.

    First, you need to consider the pricing of the Azure Data Factory and Azure Synapse Analytics services. Azure Data Factory pricing is based on the number of pipeline orchestration and data movement activities, while Azure Synapse Analytics pricing is based on the number of dedicated SQL pool nodes and the amount of data stored.

    Next, you need to consider the data transfer cost between SQL Server and Azure Synapse Analytics. The data transfer cost is based on the amount of data transferred and the region where the data is transferred from and to.

    To estimate the cost, you can use the Azure Pricing Calculator. Here are the steps:

    User's image

    1. Go to the Azure Pricing Calculator website.
    2. Select the Azure Data Factory and Azure Synapse Analytics services.
    3. Enter the number of pipeline orchestration and data movement activities for Azure Data Factory.
    4. Enter the number of dedicated SQL pool nodes and the amount of data stored for Azure Synapse Analytics.
    5. Enter the estimated data transfer volume and the region where the data is transferred from and to.
    6. Click on the "Add to estimate" button.
    7. Review the estimated cost for the services.

    Keep in mind that the estimated cost is based on the information you provide and may vary based on the actual usage. Also, make sure to review the pricing details for each service to understand the pricing model and any additional costs that may apply.

    Hope this helps. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest