Share via

Issues with Synapse Workflows After Updating Self-hosted Integration Runtime

John Brynford-Jones 31 Reputation points
2025-06-23T13:01:54.3233333+00:00

After updating the Self-hosted Integration Runtime to version 5.54.9267.1 from 5.44.xx on June 10th, the pipeline runs that previously completed in about 30 minutes are now taking several hours and worsening daily.

Uploaded image

The Integration Runtime operates on its own dedicated VM, which is managed with the Synapse Workflow. No other modifications have been made to the VM, Synapse workflows, or pipelines.

Is there a known issue with the latest version, or have the VM specifications changed?

Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

{count} vote

Answer accepted by question author
  1. Smaran Thoomu 33,920 Reputation points Microsoft External Staff Moderator
    2025-07-07T13:40:28.8833333+00:00

    Hi John Brynford-Jones
    Thank you for sharing your experience. In line with the resolution provided by the Support Team, I am sharing the findings here for the community. This information may be helpful to others who encounter a similar issue:
    Summary of Findings:

    After updating to Self-hosted Integration Runtime (SHIR) version 5.54.9267.1 or 5.55, several users (including us) noticed pipeline performance degradation, with runs taking much longer and consistently high CPU usage, even on previously sufficient VMs.

    Confirmed Issue:

    Azure Support has confirmed that there are known issues with the latest SHIR version (5.55) that may increase resource consumption or trigger throttling, especially on burstable VMs like Standard_B8ms.

    Workaround:

    As a temporary solution, we downgraded to the earlier SHIR version (5.44.x) — this immediately restored performance to normal levels.

    Azure Support has recommended this downgrade while the product team continues to investigate the issue and work on a fix for the latest SHIR version.

    If You're Affected:

    • Consider rolling back to a stable SHIR version (e.g., 5.44.x) if your pipelines have slowed significantly after the update.
    • If you're using a B-series (burstable) VM, be aware that SHIR updates may now require more CPU resources - monitor CPU usage or consider switching to compute-optimized VMs like F8s_v2 if downgrading doesn't help.

    If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.


    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members

    1 person found this answer helpful.

3 additional answers

Sort by: Most helpful
  1. Jasper Batterink 15 Reputation points
    2025-11-18T09:00:33.0066667+00:00

    Here also the same issue with multiple customer platforms (at least 3) having issues with update versions above 5.54. Since it is not publicly available here a link to download 5.54 that a colleague found: https://download.microsoft.com/download/E/4/7/E4771905-1079-445B-8BF9-8A1A075D8A10/IntegrationRuntime_5.54.9267.1.msi.

    We're also testing newer versions (up to 5.60) but keep having issues. @Smaran Thoomu , do you have any insight on a fix so we can update again maybe? In our case the customer platform have different VM's SKU (either B or D family sku's) where the same issue appears.

    2 people found this answer helpful.

  2. Anders Schou 10 Reputation points
    2025-11-17T17:00:58.19+00:00

    we the exact same issue after an automatic update of our integration runtime the 15 of November 2025. we we able to uninstall and downgrade to an earlier version. 5.50.9162.1, in order to make the ADF pipelines faster. however it was lucky we had the earlier version stored. does anyone know how to find earlier versions of the self hosted integration runtime if the issue occurs again?

    User's image

    2 people found this answer helpful.

  3. Anders Schou 10 Reputation points
    2026-03-06T03:36:02.95+00:00

    Title: SHIR v5.61.9481.1 - Severe performance regression after upgrade - anyone else experiencing this?

    Hi all,

    We recently upgraded our Self-Hosted Integration Runtime to version 5.61.9481.1 and have experienced a severe performance regression that we cannot explain by hardware alone.

    Before upgrade:

    • SHIR version: previous (now expired, cannot rollback)
    • Server: 4 cores / 16 GB RAM
    • Total pipeline runtime: ~23 minutes
    • Everything running smoothly

    After upgrade to 5.61.9481.1:

    • Server upgraded to: 8 cores / 32 GB RAM
    • Total pipeline runtime: 46-59 minutes
    • diawp.exe worker processes consume 100% CPU
    • Queue time per copy activity: ~1 minute 9 seconds
    • Actual data transfer per activity: ~3 seconds
    • 93% of activity time is spent waiting in queue
    • RAM utilization remains low — bottleneck is clearly CPU-bound in diawp.exe

    So we doubled the hardware and got more than double the runtime. The workload, pipelines, and data sources are completely identical.

    What we have tried:

    1. Reduced concurrent jobs from 16 to 8 — CPU dropped to 60% but runtime increased to 59 min
    2. Upgraded server from 4 cores / 16 GB to 8 cores / 32 GB
    3. Tested concurrent jobs at 8, 12, 16, and 20
    4. Attempted rollback to previous SHIR version — expired and cannot be installed

    Our theory is that something changed in v5.61 regarding how diawp.exe handles serialization, TLS, or worker process spawning that significantly increased CPU overhead per job.

    Has anyone else experienced similar performance degradation after upgrading to SHIR 5.61? Any workarounds or configuration tweaks that helped?

    We have opened a Microsoft support case but would appreciate any community insights.

    Thanks in advance.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.