• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 996
  • Last Modified:

General network error. Check your network documentation

We have various DTS and replication jobs running nightly between 10 SQL servers, about 20 jobs between the group.
roughly once or twice we week we will see the error below and be forced to restart a DTS job which will then work fine.
Any ideas?

ConnectionRead (recv()). [SQLSTATE 01000]
Msg 11, Sev 16: General network error. Check your network documentation. [SQLSTATE 08S0
0
DEALOGIC
Asked:
DEALOGIC
  • 3
  • 2
1 Solution
 
Kevin3NFCommented:
Generally either a hardware glitch, or the server is too busy to respond making it look like a hardware error
0
 
DEALOGICAuthor Commented:
Doubt it's a hardware issue as it occurs at completly random intervals and run diagnostic on server comes up clean.
Possible server is too busy, will need to monitor CPU and see if we are getting spikes in conjunction with the failures.
0
 
arbertCommented:
"Doubt it's a hardware issue as it occurs at completly "

Not necessarily a hardware error.  Can also indicate VERY heavy IO.  Take a look at Windows Perfmon.  Anything else running on the server besides SQL Server?

Here is a good MS checklist as well:

http://www.perfect-computing.com/network.ppt

Brett
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Kevin3NFCommented:
So....which was it?  Hardware or Server too busy?
0
 
DEALOGICAuthor Commented:
seems to be server too busy.  we reduced the load a bit and are getting error less often.
0
 
Kevin3NFCommented:
Good deal.  Any reason for the C grade?  If you had additional questions I would have been happy to answer them :-)
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now