Took a long time to load data from Azure SQL Database into ADLS Gen2 by using Azure Synapse Analytics

Liang Chen 1 Reputation point Microsoft Vendor
2022-04-05T18:05:48.533+00:00

Hi,

I tried to use the Copy Data Activity to load ~58GB data into ADLS Gen 2 by using Synapse Pipeline. It took around 1 hour to do so. However, when I used the Copy Data Activity with the same configuration in ADF Pipeline, it only took several minutes. I was wondering why since we both use the same pipeline in two scenarios. Is there any way that I could load data from Azure SQL Database in Synapse as fast as in ADF? Please help. Thank you very much.

190325-inkedtroubleshoot1-li.jpg

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,687 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,180 questions
{count} votes