Hello NG,
We have a performance problem in using a client server solution based on MS SQL-Server 2000 through a VPN tunnel (via broadband internet connection).
The SQL Server is running on a Windows 2003 Server which is configured as VPN server as well.
We figured out that not the performance of the VPN tunnel itself is the problem, but the problem is the access to the MS SQL Server.
We tested it by executing sql statements on the Query Analyzer on the VPN client (WIN XP built in) which is connected to the server through the tunnel.
For example execution of the SELECT statement "select TOP 1000 * from Items" on the database trough the tunnel takes more than 30 times as much than the same execution on the server itself or within the server's local network.
But we can make FTP downloads from our server through the tunnel with 600 KBit/s under same conditions so the bandwidth of the tunnel should not be the problem.
Do you have any ideas how we can accelerate this or does any one has made experiences related to this topic?
Thanks for your help!
JENS