If you have slow or non responsive program properties; such as a database or other network program…Right Click on My Computer, go to Properties, select Hardware, Device Manager, click the + sign on Network, Right Click on your network card, select properties, select the Advanced Tab, Look for Speed – adjust the value to 100 Full Duplex, 100 Half or even select the 10 settings. Try it on each of the settings to see which one is optimal for your network.
When computers handshake (exchange data) autosense does not always work.
I’ve had replaced network cards, ran winsock fix and tried everything when the solution was right in front of me.
You should also disable everything under the Advanced Tab except Flow Control.
For SQL, see our LLMNR Article