Share via

How to improve throughput of COPY activity

Anonymous
2020-08-03T21:02:14.39+00:00

Hello, Please advise me to improve the throughput of data copy from SAP. ![15331-image.png][1] [1]: /api/attachments/15331-image.png?platform=QnA The same number of rows copy from another SAP server(different SHIR), but that has high throughput. Your pointers will be a real help. Thanks,

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,480 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,819 questions
0 comments
Accepted answer
  1. Vaibhav Chaudhari 38,746 Reputation points
    2020-08-04T04:46:12.947+00:00

    You could check what exactly is different in another SAP server where performance is good.

    Also try to increase DIU and Parallel copies settings for the copy activity. See if below document helps

    copy-activity-performance

    ===============================================

    If the response helped, do "Accept Answer" and upvote it -- Vaibhav

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.