Forum Discussion
Incremental Refresh Synapse - Reduce Number of Concurrent Session
It's not clear whether you are using gateway here or not. In case you aren't using gateway, you can try setting up gateway for Synapse since synapse supports gateway.
By using the gateway, there is possibility to control the concurrent connections to the source. We need to change a setting in gateway configuration file to make it work. Please refer to the below doc.
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance-cpu
You need to change the below mentioned field value to the desired number of concurrent connections.
MashupDefaultPoolContainerMaxCount
Did I answer your questions? Give a thumbs up and accept this post as solution!
Ahh thank you, thats a great idea, I will give that a go.
We are not using the gateway at the moment, I will give that a go this morning and let you know if that solves it.