Depending on the server design it may have multiple network ports built into the motherboard but I’d still recommend putting a high quality network card in the computer to eliminate any problems that might continue on these other ports. Relatively cheap, easy method to eliminate the network ports from the troubleshooting quagmire.
Paul
Sent from my iPhone
On Jul 13, 2018, at 5:55 PM, M Jarvis brewdaddy@gmail.com wrote:
On Fri, Jul 13, 2018 at 2:44 PM, Paul H. Tarver paul@tpcqpc.com wrote:
Not sure whether this will apply to you or not, but I recently had a client running an ERP for hundreds of client databases spread over multiple servers. We became aware of problem they were having with random timeouts to a specific server. Since all our other server connections were working fine (ie: never timing out), I suggested they check the network card, network cable & network port on the switch. Report [OT] Abuse: http://leafe.com/reportAbuse/00c501d41af2$b7f324c0$ 27d96e40$@tpcqpc.com
<snip>
Thanks Paul....
After I posted our IT guys started talking about the server waiting on ASYNC_NETWORK_IO. More or less they said it seems like SQL is serving up the data but our client end software (our stuff) can't keep up. They said all indications on the server performance when this is happening is that everything is just dine, memory is dandy, all is well.
So perhaps the bottleneck is our software (quite possible) or the net card, or something else. *Something* is strangling the throughput and I'll bet swapping out the card is a quick and easy thing to do (easy for me to say since I'm not the one to do it).
I'll mention it to them. Thanks again...
-- Matt Jarvis Eugene, Oregon USA
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]