How working and total duration calcualte in COPY Activty in Data factory

Question

Hello, Please help me to understand how the working duration and total duration calculates in COPY activity. ![15291-image.png][1] [1]: /api/attachments/15291-image.png?platform=QnA In my case:- Reading from Source: 00:00:23 - only 23 taken to read from the source(SAP table) Writing to Sink: 00:00:05 - only 05 seconds to write to the destination(ADLs). but hard to understand how 00:08:50 total time taken? Please help me to demystify. Thanks in advance.

Answer 1

Hi anonymous user,

I confirmed with Product team and they are working on enhancing the documentation to explain the difference in total duration and working duration metrics for copy activity with examples. As mentioned, Total duration means the overall duration for each steps (in your screen shot, it has the queue duration and the transfer duration). and working duration doesn't include all components now which may lead to confusion. E.g. the serialization working duration is not included. Please do share specific activity run id, and we can further take a look to double confirm with the Product team.

Please suggest if this clarifies the question and hope to hear back with run ID from you.