ADF Copy activity runs for too long

Your ADF copy activity is timing out because of slow write throughput to Azure SQL combined with self-hosted IR bottlenecks. Common causes include network latency from on-prem to Azure, insufficient batch size or parallelism, Azure SQL throttling, or interim staging table overhead. You can improve performance by tuning batch size, parallel copy settings, staging options, and IR resources, and by monitoring Azure SQL DTU/CPU usage.