Recently moved some VM's to Azure. We now have significantly higher latency to on-prem where we load data from DB2. Around 25ms over the ExpressRoute vs 1-2ms on-prem->on-prem.

We are now suffering on very low performance reading data with SSIS packages with jobs taking 6x longer than onprem->onprem. The job is a simple SELECT * Any ideas on how to work around the higher latency? And get more troughput?