To diagnose network problems, our team pays special attention to the NETWORKIO wait type, which the "Wait Types, Perfmon Counters, and Correlations" document includes. (You can download the full document at InstantDoc ID 40925.) The NETWORKIO wait type indicates that SQL Server has sent results to the client and is waiting for an acknowledgement. Network bandwidth and packet sizes are important considerations when NETWORKIO is high. You can think of packets as the containers that an application ...