Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Other SQL Server Topics / September 2007

Tip: Looking for answers? Try searching our database.

Network Packet Size

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kmounkhaty@gmail.com - 27 Sep 2007 16:57 GMT
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,
Erland Sommarskog - 28 Sep 2007 22:35 GMT
> 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
[quoted text clipped - 15 lines]
> 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.

Signature

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

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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.