An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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_v2if 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