Don't take this the wrong way, but most people tend to put the blame on the software and SQL. Everyone uses the same AC (well different versions) and SQL, but all use different networks. There is a saying in IT which basically says, if you are having trouble connecting, it is likely DNS, DNS, DNS. And, the same with slow connectivity -- network, network, network.

As far as cables, etc. that really is rather easy. If you unplug the Ethernet cable from the server, you know whether cable end is. Wrap some tape around it. If you have a laptop, you can use it. If not, just disconnect the cables from a computer, move it closer to the server and connect both to a 1GB Netgear switch. You can get one on Newegg for about $40 to $60. Then run your speed test and do some things with AC. At home I have a 100 foot Cat6 Ethernet cable. You can always run a long cable from a computer to the switch.

Not to be redundant, but if that is fast, then move the new switch to where the real switch is and connect the server and two computers to the switch. You can connect the router if you want. If that is fast (basically the same thing as the experiment from before), then you have to wonder if it is the old switch.

Lastly, and we mentioned this before is the Link speed. If you go to the device manager and find your NIC card, right click, select properties, Advanced, you should see Link Speed & Duplex in the drop down list. You will see everything from 10 Mbs half duplex to 10 Mbs full deplex up to 1000 Mbs half and full duplex. Obviously, 1 Gbs full duplex is as fast as you can get, it is still best to let the card set the speed automatically as it will set it for the fastest speed. You would see a rather large difference between 10 Mbs Half Duplex and 1000 Gbs. Now I doubt this is the problem, because I doubt every computer has their NIC cards set to the slowest setting. But, who knows, maybe at one time, your cables handled 100 Mbs or your switch did, so someone thought they needed to match.

[Linked Image from ]
[Linked Image from ]

By the way, my speed test is consistently 0.25, and mine runs fine. But one man's fast is another man's slow. But, I can open II in less than a second.


Bert
Pediatrics
Brewer, Maine