Is my case a Network Issue or database optimization issue -- which one to assign more significance?
From: Avi (avisemah_at_optonline.net)
Date: 05/14/04
- Next message: Dominic: "Re: Master Browser within Win2k pure environment ?"
- Previous message: Dan: "Re: Windows 2000 Not Routing Correctly"
- Messages sorted by: [ date ] [ thread ]
Date: 13 May 2004 21:17:24 -0700
I have at my house a WORKGROUP setup composed of windows server 2000
(Call it computer S) on which sql 20000 is installed and another
windows 2000 computer (call it Computer C). I also have visual basic
application running on computer C independently, except for some data
fetching that it does by relying on the SQL server database in
computer S. When the application runs in the private network context,
I don't experience any performance problems, some process that
involves execution of vb code and data fetching from SQL server lasts
no more that a second. Howver, when I hold everything constant except
for taking computer C out of the private network and connection it
through a DIFFERENT isp, I do experience a remarkable performance
degradation. The same process that last a second in the private
network, lasts more than 30 seconds with the remote connection.
Is it possible that I'm experiencing a network bottleneck or is it
normal to see such differnces when computer C moves from a private
network that enjoys a speed connection of 1.5 Mega bits per second to
an ISP that supplies 192 Kbs. Please bear in mind that the same
process was also measured when computer C moved to a different ISP but
with a same internet speed. In that latter case, the performance was
only 10 times slower, as opposed to 30 times slower when the
connection was 192 Kbs. So as you can see, in the 3 case described
above, the only parameter that changed was the IP address of the
connection string that computer C uses in order to connect to the sql
server of computer S. In private network S's IP address with respect
to Computer C's address was 192.168.0.2, in case 2 it was something
like 24.191.235.35.
Can anyone, just by the mere observation of what I described, have an
idea what I should do -- optimize my database performance first (e.g,
indexing, searching for blocking) or conxentrate on the network? If
networking is the culprit, have you seen such cases where the
performance degrades when moving from local to remote connection?
Any assistance will be much appreciated
Avi
- Next message: Dominic: "Re: Master Browser within Win2k pure environment ?"
- Previous message: Dan: "Re: Windows 2000 Not Routing Correctly"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
