SQL apps slow over VPN
Posted on 2011-03-01
Hi, I have a 22down/5up cable connection at two sites and have a BOVPN between the two (both Watchguard XTM 505, 11.4). Everything is running swimmingly with windows file transfers, internet, Outlook and other applications getting expected speed - approx 5Mb/s.
However, we have two VB apps that pull data from our SQL server at one of the sites, and when they are accessed from the other site through the VPN they take an extremely long time to start up, and an annoying amount of time accessing different records once they are open.
Previous to this set up we had a 1Mb/s P2P connection between the two sites, and that was also annoyingly slow, but it was two times faster than what we are now getting through the VPN. I 'm probably getting a little more latency from this connection (20-30ms) than our previous one (15-20ms).
I know the encryption will add a little overhead, but other traffic is working just fine and the VPN is rated to 250Mb/s.
Can anyone provide some insight as to what might be causing the slowness for these apps or any troubleshooting I can try to track it down?
I've already tried changing the SQL connection string at the remote site to the IP of the SQL server instead of the NETBIOS name and that had no effect.
Thanks very much!