I have a strange problem that suddenly happened.
I have a Windows 7 Ultimate OS running SSMS 2008. When I run a query or an stored proc against a server (the server is remote and passes through a VPN tunnel) it can take me 40 seconds to get the query to complete. But when I run a similar query against
another server located at the same location (go through the same tunnel) I get the results in 1 second. I select about 400 rows on both servers.
The slow response comes from a server that runs sql 2005 and the fast response is sql 2008. I asked a friend that works in the same office with me and uses the same connection as I do to run the same queries and he gets the result in 1 second.
Does anyone has any ideas what can cause such problems? I tried to remove and reinstall all the sql server components from my computer but nothing helped?
View Complete Post