Forum Discussion
Incremental Refresh Synapse - Reduce Number of Concurrent Session
Solution SpecialistIt'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!
_sfrost just wanted to check with this, would you expect to use the on prem gateway and somehow shoehorn it to working cloud to cloud or is there another type?
Ive just had a look and am not sure where to start with that part, any pointers would be appreciated
- _sfrost
Though your source is cloud and doesn't require gateway for refresh, we can still set up gateway to control the number of concurrent sessions. That's the reason I suggested you to use gateway and I am not sure if we can control this if we do not use gateway.
To start with, install a gateway and add your Synapse datasource under that gateway.
Once set up, follow the article I provided and change the gateway configuration file.
Once done, do a refresh and observe the behaviour.
Morning, I spent all of yesterday looking into Gateways and the issue I have is that I don't have a machine to stand the on prem gateway on, so I was looking into VNet gateways.
Do you know if there is anyway to do the what you surguest with them.
I now have one setup and get the concurent connections errors, but I don't know where to start in limiting these in the Vnet Gateway. Any pointers?
- v-robertq-msft
Community Support
Hi, jlf81
According to my research, Azure VPN Gateways limit the number of Point-to-Site (P2S) connections allowed to a single gateway. SSTP Connections are limited to 128 concurrent connections for all VPN Gateway SKUs. There is not way to increase this limit, but most VPN clients will support one of the other protocols so connecting over a different protocol may help avoid the limit.
I think you can also refer to these documents to get the troubleshooting guidance and check if they can be helpful:
https://www.bluematador.com/docs/troubleshooting/azure-vpn-gateways
https://docs.microsoft.com/en-us/azure/vpn-gateway/vpn-gateway-troubleshoot
https://docs.microsoft.com/en-us/azure/vpn-gateway/tutorial-create-gateway-portal
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
