dbTalk Databases Forums  

Network Packet Size

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Network Packet Size in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
kmounkhaty@gmail.com
 
Posts: n/a

Default Network Packet Size - 09-27-2007 , 10:57 AM






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,


Reply With Quote
  #2  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Network Packet Size - 09-28-2007 , 04:35 PM






(kmounkhaty (AT) gmail (DOT) com) writes:
Quote:
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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.