SSIS Package slow only on one of AG Instance

Copper Contributor

Dear All,

We have 2 node availability group. We have one SSIS Package that always takes less than an hour to execute on Node1 (wheneever it is primary replica) but always takes more than 4 hours on the other node (say Node2, (wheneever it is primary replica). The resources (CPU, Memory) all are same across the nodes. Any idea what is going on?

SQL Server 2016 (Build 13.0.7024.30)

Windows 2016

Regards,

0 Replies