SQL Server Performance

Network Packet Size

Discussion in 'Performance Tuning for DBAs' started by KongDBA, Sep 27, 2007.

  1. KongDBA New Member

    Hi Guru,
    After we moved from old server (windows 2000, SQL 2000 and SP3a) to a new server (windows 2003, SQL 2000 and SP4) that cutting down maximum network packet size to a half, we run into a new issue below:
    Message : General network error. Check your network documentation.
    Source : .Net SqlClient Data Provider
    Help link :
    Errors : System.Data.SqlClient.SqlErrorCollection
    Class : 20
    LineNumber : 0
    Number : 11
    Procedure : ConnectionWrite (send()).
    The default timeout of our application is 60 seconds and SQL still runs on default netowrk packet size value which is 4096. Switch and NIC settings are exactly the same compared to old machine. I'm not ready to bump up the network packet size value from default configuration. Also, our developer indicated that the time out is not from app server.
    What is the solution of fixing this issue?
  2. satya Moderator

    I thought it may have been related to connection pooling and you might test this by using the second connection to use different SQL credentials - this should make the two connections forced into separate pools - as the connection string is what is used to pool connections together.

    Also refer to this KBA http://support.microsoft.com/default.aspx?scid=kb;en-us;899599 for a relevant information.

Share This Page