patternMinor
SQL Server query result transfer time over VPN (WAN)
Viewed 0 times
resultwanvpnsqlquerytimeserverovertransfer
Problem
I have a mysterious phenomenon on one remote SQL Server 2005 which I manage and query using SQL Server Management Studio. I connect to the server through a VPN tunnel (provided by an ISP, about 8 MBit/s up and down).
When I open a new query window (first connection) the result is quickly transferred to the client. Let's say Update: as suggested in the comments I cross posted on Serverfault.com.
When I open a new query window (first connection) the result is quickly transferred to the client. Let's say Update: as suggested in the comments I cross posted on Serverfault.com.
Solution
In your VPN properties, click options, PPP Settings.
Do you have "enable software compression" ticked?
SQL data compresses quite nicely, and if the remote site is heavily used bandwidth wise, it may simply be struggling to send you the data.
Do you have "enable software compression" ticked?
SQL data compresses quite nicely, and if the remote site is heavily used bandwidth wise, it may simply be struggling to send you the data.
Context
StackExchange Database Administrators Q#4738, answer score: 3
Revisions (0)
No revisions yet.