Network Packet Size

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?

Thanks,
Silaphet,

Re: Network Packet Size

(kmounkhaty@gmail.com) writes:
> 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.

Some more information should help. Are the clients able to connect, but
get random disconnections with the message above? Or what is going on?

If you get disconnections, I would suspect network problems. Whether that
is related to the packet size is not within my realm of expertise.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx