ADF V2..Pipeline长时间卡住而没有任何活动的问题 [英] Issue with ADF V2 ..Pipeline stuck for long time without any activity

问题描述

大家好，

我正在使用ADF v2将数据从prem sql源复制到azure数据仓库.它是一个多表副本，我注意到的是，复制活动仅花费1万行数据(大约1小时)就花费大量时间.附件是吞吐量的屏幕截图 一样的.此问题不一致，因为对于相同数据源进行的其他类似活动所花费的时间要少得多.请提供任何解决此问题的方法，因为复制数据似乎很慢.

I am using ADF v2 to copy data from on prem sql source to azure data warehouse. its a multiple table copy and what i noticed is the copy activity is taking huge amount of time for just 10k rows of data( approx 1 hour). Attached is the screenshot of the throughput of the same. This issue is inconsistent as for other similar activity to same data source takes very less time. Kindly provide any way to troubleshoot this issue as its seems to be to slow for copying data.

推荐答案

您的描述中似乎缺少了屏幕截图.您可以尝试重新连接.

也请参考 复制活动性能和调优指南可以提高性能并检查根本原因.

Also, refer Copy Activity performance and tuning guide to improve the performance and check the root cause.

这篇关于ADF V2..Pipeline长时间卡住而没有任何活动的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！