I apologize for leaving this question here, but nothing else seems even close to the appropriate place. I'm troubleshooting a performance problem where a query to a database installed on SQL 2008 is running slower than it did on 2005 running on
slower/older hardware. I noticed in the network traffic that the server is sending an 8000 byte TDL response packet (using several network packets) but it stops immediately and waits until it get's an ACK back from the client This appears to be slowing the
The client and server are configured to use up to a 64K TCP window, but there is never more than 8K in flight at any time because of the delays waiting for ACKs.
Is this normal for SQL Server; a part of the design, or what? I'm not so concerned with the size of the response packets, I just don't think the server should be so squimish about sending out data, if it's there to send, and if the network isn't fully utilized.
If you know how to fix this, I would appreciate your help very much. Thanks!
View Complete Post