remote SQL access much slower than local
Posted on 2013-12-05
i have an application that does fairly simple lookups on a sql server 2008 database.
i have a local to the server workstation, which has REALLY fast response time.
i have a remote (several blocks away) workstation which is slower in general, but occasionally REALL REALLY REALLY slow.
an internet speed test at
location where server is
download 2.92 mbps
upload 1.30 mbps
location where remote workstation is
as a refference i also did a speed test from my machine
so... there is obviously a bottle neeck of avalable speed at the server site.
my questions are this..
what do i look for in my code to try and determine why there is such a big difference in
performance between the local workstation and the remote workstation.
what can i monitor to determine if there is a something going on with the network at the times it is REALLY REALLY REALLY slow.