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