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.
Changing Default Synapse Integration Runtime Settings
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 57.00000000000001%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vamsi Madhav
46
Reputation points
Problem1: Performance issues on one Environment
So my problems started after moving my development pipelines (north europe) to a new domain Synapse Prod (west europe) where our AD works. all my pipelines that run in about 30mins take consistently longer. I cant see any obvious difference in them as I used ARM templates to build them. I exported both the templates and compared and couldnt find much difference.
Problem2: Not able to change the Integration runtime settings
In this process of comparing I was trying to see if there is a way I could change the default Integration Run time on my synapse pipelines ? currently all my pipelines are using "AutoResolveIntegrationRuntime" in both environments.
Problem3: not able to stop the Runtime from Shell
I tried Stopping the runtime from a Cloud Shell hoping to be able to change the compute size - but ended up with a not so helpful situation that i cant seem to find a way forward with.
PS /home/azureuser> Stop-AzSynapseIntegrationRuntime -WorkspaceName wpabbasynapsedev -Name 'AutoResolveIntegrationRuntime' -Force
Stop-AzSynapseIntegrationRuntime: One or more errors occurred. (Operation returned an invalid status code 'MethodNotAllowed')
Problem4: changing the default Runtime
I also tried changing the pipelines to use a Manually created integrationRuntime - but not really sure where i could enforce this across the pipelines - we use a lot of pipelines with copy, data flows, procedure calls and rest api calls - all of which dont give an option to select a integration runtime. All the documentation i find shows how you could change the default value in ADF where there seems to be an option - but i dont see a similar link for Synapse.
Any help resolving one of the problem would hopefully provide a solution to improve things, and would be appreciated. thanks in advance.
Azure Synapse Analytics
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator2023-02-25T01:04:39.2+00:00 @Anonymous Hi @Anonymous ,
Thanks for using Microsoft Q&A forum and posting your query.
Problem1: Performance issues on one Environment -
Since you have mentioned there is a change in the region, which could be one reason that is impacting the performance. Basically, the closest the IR region to the Data store, the better performance you will have.
I would also recommend having a look at the below Performance tuning steps and see if that helps to improve the performance of your processing.
Ref doc: ADF Performance tuning tips
Problem2: Not able to change the Integration runtime settings.
If you are trying to change the Default Integration runtime, then the answer is
NO. The default Integration runtime is managed by Azure and cannot be changed.Problem3: not able to stop the Runtime from Shell
The default Integration runtime cannot be changed or stopped as it is managed by Azure. Please note that only Azure SSIS IR and SHIR can be stopped and started but not the Default Integration runtime or the Custom Azure IR.
Problem4: changing the default Runtime:
I'm checking on possible workaround for this requirement and will get back to you soon.
Thank you
-
KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator
2023-03-03T23:56:45.7133333+00:00 **Problem4: changing the default Runtime:
**
To change the IR, you may have to go toManagesection in Studio and then go toIntegration runtimesunderConnectionstab and then look forRelatedcolumn to identify the reference and manually update the references.In case if you think that is not an optimal solution, I recommend filing a support ticket so that a support engineer can have a deeper look into the performance issue and suggest necessary changes to improve it.
Hope this info helps.
Sign in to comment
Sign in to answer