Hi @CON-Thirusenthilkumar Pandiyan
Welcome to Microsoft Q&A platform and thanks for posting your question here.
Here are the reasons and solutions for slow performance when loading 5 tables with more than 1 billion records each from SAP On-Prem to ADLS Gen2 using ADF Copy activity.
When loading 5 tables with more than 1 billion records each from SAP On-Prem to ADLS Gen2 using ADF Copy activity, slow performance can be caused by several reasons. These include high network latency, large data volume, complex data structure, insufficient hardware resources, and improper copy activity configuration.
Here are the steps you can take to optimize the performance when transferring large amounts of data from SAP On-Prem to ADLS Gen2 using ADF Copy activity:
- Use Azure ExpressRoute or VPN Gateway to establish a dedicated and private connection between the SAP On-Prem source and ADLS Gen2 to reduce network latency.
- Filter out unnecessary data, reduce the number of columns, and use incremental loading to optimize data transfer.
- Flatten the data, denormalize the data, and use simple data types to optimize the data structure.
- Increase the memory, CPU, or disk space of the source system or destination system to optimize hardware resources.
- Optimize the copy activity configuration by setting the "parallel Copies" property, using Polybasic, or leveraging the partition option.
- Use Azure Monitor to monitor performance metrics and troubleshoot any issues.
Reference:
https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-performance-features
https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-performance-troubleshooting#troubleshoot-copy-activity-on-self-hosted-ir
I hope this information helps you. Let me know if you have any further questions or concerns.