ADF Data Copy Between Azure SQL DBs has slowed over the last week

%3CLINGO-SUB%20id%3D%22lingo-sub-1689834%22%20slang%3D%22en-US%22%3EADF%20Data%20Copy%20Between%20Azure%20SQL%20DBs%20has%20slowed%20over%20the%20last%20week%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1689834%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20noticed%20delays%20due%20to%20queuing%20in%20ADF%20when%20copying%20data%20from%20one%20Azure%20SQL%20Db%20to%20another%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20use%20ADF%20to%20copy%20large%20volumes%20of%20data%20between%20Azure%20SQL%20DBs.%20The%20time%20to%20process%20these%20are%20increased%20dramatically%20over%20the%20past%207%20days.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20example%20of%20this%20would%20be%2C%20ADF%20took%2013%20mins%20to%20copy%2040%20tables%20last%20week.%20This%20is%20not%20now%20over%20an%20hour%20to%20process%20with%20similar%20data%20volumes.%20In%20the%20ADF%20screens%20it%20is%20showing%20increased%20values%20in%20the%20queue%20time%20on%20the%20individual%20table%20copy%20details.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20thinking%20this%20increased%20process%20time%20could%20be%20related%20to%20an%20ADF%20update%2Frelease%20on%20the%20private%20endpoint%20connection%20option.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1689834%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

 

Has anyone noticed delays due to queuing in ADF when copying data from one Azure SQL Db to another?

 

We use ADF to copy large volumes of data between Azure SQL DBs. The time to process these are increased dramatically over the past 7 days.

 

An example of this would be, ADF took 13 mins to copy 40 tables last week. This is not now over an hour to process with similar data volumes. In the ADF screens it is showing increased values in the queue time on the individual table copy details.

 

We are thinking this increased process time could be related to an ADF update/release on the private endpoint connection option.

 

Thanks.

 

 

0 Replies