VPN connection slow for SSMS

Hello,

We are currently using AWS infrastructure. Previously we were using AWS client VPN and everything was working fine. It got very expensive so we decided to move to Pritunl. We got everything running and everything seems to be working great.

The only thing we are seeing an issue with is using Microsoft SQL Management studio. It is very slow to even connect and log in. Just moving through the database and tables are really slow. When using the AWS VPN we did not see this issue at all.

Does anyone have an suggestions on what may cause this? Or anything that we might change to fix this.

The primary resource used by the VPN is CPU and specifically single thread performance. Select one of the C series instances that have non-shared CPU cores. Shared CPU instance types will be significantly slower. Verify the cipher is configured to AES-128, WireGuard servers may provide faster connections.