ADF Copy Activity slow after downgrade IR to 5.45.8999.1

Question

ADF Copy Activity slow after downgrade IR to 5.45.8999.1

c-8484 0

Hi,

We recently downgraded IR to 5.45.8999.1 to get around the issue related to 5.48.9106.2 that was causing 'NpgsqlTypes.NpgsqlInterval' errors. While we no longer having the 'NpgsqlTypes.NpgsqlInterval' errors with 5.45.8999.1, our copy activity became very slow where it can take 3 hours to extract a table when it took minutes previously.

We have since upgraded back to 5.48.9106.2 based on instructions from our MSFT support. Although we are not getting the 'NpgsqlTypes.NpgsqlInterval' errors, we continue to experience the slowness.

Do you happen to have the same experience? If you do, do you happen to know the cause / solution?

Thank you for your help!

phemanth 15,765 Reputation points Microsoft External Staff Moderator

2025-04-11T03:42:07.6566667+00:00

@Fan Weik

could you please provide details as below

If you're using a Self-hosted IR, ensure it has enough resource please confirm on which region you are using

and also, could you please provide the screenshots of your integration runtime configuration

Check if your data stores are being throttled. If many read/write operations are throttled, you might need to increase the allowed request rate for the data store or reduce the concurrent workload
c-8484 0 Reputation points

2025-04-11T17:22:15.1+00:00

@phemanth, we are in us west. Do you happen to know if there are issues that might cause the slowness?

The throughput is 5 times slower since 5.45.8999.1 even though our configurations have not changed.
Singireddi JagadishKumar 0 Reputation points Microsoft External Staff Moderator

2025-04-15T06:15:29.3833333+00:00

Hello @Fan Weik
I just wanted to follow up and see if you had a chance to review my response to your question. Please let us know if it was helpful, and feel free to reach out if you have any further queries
c-8484 0 Reputation points

2025-04-17T02:37:33.5333333+00:00

Hi Singireddi, thank you for getting back to me. I just saw your comments. Thank you very much for your suggestions. Our MSFT support engineer also suggested upscaling so it's good to know that your suggestion agrees with it. Our support engineer also mentioned version 5.52. Have you heard much about version 5.52? Thanks again.
Singireddi JagadishKumar 0 Reputation points Microsoft External Staff Moderator

2025-04-17T07:11:44.54+00:00
@Fan Weik, this is latest version IntegrationRuntime_5.52.9222.3.msi

You can follow the above link to download latest version.

Self-hosted integration runtime auto update and expire notification.

Release notes of Self-hosted Integration Runtime (SHIR) version 5.52.9222.3

I also verified on my end that the latest version of the Self-hosted Integration Runtime (SHIR) is 5.52.9222.3. Please check the screenshot below for reference.
Singireddi JagadishKumar 0 Reputation points Microsoft External Staff Moderator

2025-04-22T11:00:48.47+00:00

Hi @Fan Weik , Just checking in to see if the provided answer helped. If it did, please click "Accept the answer” and Yes for the answer . So it can benefit other community members reading this thread. If you have any further queries, do let us know.
c-8484 0 Reputation points

2025-04-25T23:26:07.6+00:00

Thanks Singireddi for following up on 5.52. We found 5.48.9106.2 is working ok after we resolved some network issues. The IR troubleshoot info you provided is helpful regardless - it's always good to have the list as a systematic way to troubleshoot going forward. I really appreciate your help.
Singireddi JagadishKumar 0 Reputation points Microsoft External Staff Moderator

2025-04-28T11:53:32.0633333+00:00

Hi@c-8484
Thank you for your response and I'm so glad that you found the right version for the above issue.
Singireddi JagadishKumar 0 Reputation points Microsoft External Staff Moderator

2025-04-29T12:12:52.02+00:00

@c-8484
I am following up to ensure the provided response was helpful. If it addresses your query, kindly click Accept Answer. Should you have any additional questions, please let us know.

1 answer

Your answer

phemanth 15,765 Reputation points Microsoft External Staff Moderator

2025-04-11T03:42:07.6566667+00:00

@Fan Weik

could you please provide details as below

If you're using a Self-hosted IR, ensure it has enough resource please confirm on which region you are using

and also, could you please provide the screenshots of your integration runtime configuration

Check if your data stores are being throttled. If many read/write operations are throttled, you might need to increase the allowed request rate for the data store or reduce the concurrent workload
c-8484 0 Reputation points

2025-04-11T17:22:15.1+00:00

@phemanth, we are in us west. Do you happen to know if there are issues that might cause the slowness?

The throughput is 5 times slower since 5.45.8999.1 even though our configurations have not changed.
Singireddi JagadishKumar 0 Reputation points Microsoft External Staff Moderator

2025-04-15T06:15:29.3833333+00:00

Hello @Fan Weik
I just wanted to follow up and see if you had a chance to review my response to your question. Please let us know if it was helpful, and feel free to reach out if you have any further queries
c-8484 0 Reputation points

2025-04-17T02:37:33.5333333+00:00

Hi Singireddi, thank you for getting back to me. I just saw your comments. Thank you very much for your suggestions. Our MSFT support engineer also suggested upscaling so it's good to know that your suggestion agrees with it. Our support engineer also mentioned version 5.52. Have you heard much about version 5.52? Thanks again.
Singireddi JagadishKumar 0 Reputation points Microsoft External Staff Moderator

2025-04-17T07:11:44.54+00:00

@Fan Weik, this is latest version IntegrationRuntime_5.52.9222.3.msi

You can follow the above link to download latest version.

Self-hosted integration runtime auto update and expire notification.

Release notes of Self-hosted Integration Runtime (SHIR) version 5.52.9222.3

I also verified on my end that the latest version of the Self-hosted Integration Runtime (SHIR) is 5.52.9222.3. Please check the screenshot below for reference.
Singireddi JagadishKumar 0 Reputation points Microsoft External Staff Moderator

2025-04-22T11:00:48.47+00:00

Hi @Fan Weik , Just checking in to see if the provided answer helped. If it did, please click "Accept the answer” and Yes for the answer . So it can benefit other community members reading this thread. If you have any further queries, do let us know.
c-8484 0 Reputation points

2025-04-25T23:26:07.6+00:00

Thanks Singireddi for following up on 5.52. We found 5.48.9106.2 is working ok after we resolved some network issues. The IR troubleshoot info you provided is helpful regardless - it's always good to have the list as a systematic way to troubleshoot going forward. I really appreciate your help.
Singireddi JagadishKumar 0 Reputation points Microsoft External Staff Moderator

2025-04-28T11:53:32.0633333+00:00

Hi@c-8484
Thank you for your response and I'm so glad that you found the right version for the above issue.
Singireddi JagadishKumar 0 Reputation points Microsoft External Staff Moderator

2025-04-29T12:12:52.02+00:00

@c-8484
I am following up to ensure the provided response was helpful. If it addresses your query, kindly click Accept Answer. Should you have any additional questions, please let us know.

Answer 1

@Fan Weik

I'm giving your resolution as an answer so that it will help the community to find better solution.

Issue:

customer facing was issue in the version 5.45.8999.1 with error NpgsqlTypes.NpgsqlInterval, switching back to version 5.48.9106.2 getting know error but experiencing slowness in copy activity.

Solution:

Found that version 5.48.9106.2 is working fine and issue is related to network

however, it is recommended use the latest version 5.52.9222.3

Know more about Troubleshoot copy activity on Self-hosted IR

and check this link for latest version IntegrationRuntime_5.52.9222.3.msi

Please do not forget to click "Accept the answer” and Yes wherever the information provided helps you, this can be beneficial to other community members.

If you have any other questions or still running into more issues, let me know in the "comments" and I would be happy to help you.

Singireddi JagadishKumar 0 Reputation points Microsoft External Staff Moderator

2025-04-21T13:11:13.43+00:00

@Fan Weik
Just checking in to see if the provided answer helped. If it did, please click "Accept the answer” and Yes for the answer . So it can benefit other community members reading this thread. If you have any further queries, do let us know.

Share via

ADF Copy Activity slow after downgrade IR to 5.45.8999.1

1 answer

Your answer