Following is a print out of a portion of errorlog. I constantly get
these errors on all my sql servers. Any one knows if it will hurt query
performance. What can I do to get around it or get rid of it
A network error was encountered while sending results to the front end.
Check the SQL Server errorlog for more information.
1999/05/20 10:22:18.23 spid18 DBCC TRACEON 208, SPID 18
1999/05/20 10:22:18.54 spid19 DBCC TRACEON 208, SPID 19
1999/05/20 11:35:58.26 spid20 DBCC TRACEON 208, SPID 20
1999/05/20 11:35:58.89 spid24 DBCC TRACEON 208, SPID 24
1999/05/20 11:40:46.39 ods Error : 17824, Severity: 10, State: 0
1999/05/20 11:40:46.39 ods Unable to write to ListenOn connection
'1433', loginname 'sa', hostname 'M78-HWMAR'.
1999/05/20 11:40:46.39 ods OS Error : 64, The specified network
name is no longer available.
1999/05/20 11:40:46.42 spid24 Error : 1608, Severity: 21, State: 2
1999/05/20 11:40:46.42 spid24 A network error was encountered while
sending results to the front end. Check the SQL Server errorlog for more
information.
1999/05/20 12:01:39.50 ods Error : 17824, Severity: 10, State: 0
1999/05/20 12:01:39.50 ods Unable to write to ListenOn connection
'1433', loginname 'sa', hostname ''.
1999/05/20 12:01:39.50 ods OS Error : 64, The specified network
name is no longer available.
1999/05/20 12:01:53.46 spid16 DBCC TRACEON 208, SPID 16
1999/05/20 12:01:53.76 spid24 DBCC TRACEON 208, SPID 24
1999/05/20 12:04:44.45 spid26 DBCC TRACEON 208, SPID 26
1999/05/20 12:04:44.84 spid27 DBCC TRACEON 208, SPID 27
1999/05/20 12:12:44.04 ods Error : 17824, Severity: 10, State: 0
1999/05/20 12:12:44.04 ods Unable to write to ListenOn connection
'1433', loginname 'sa', hostname 'M78-HWMAR'.
1999/05/20 12:12:44.04 ods OS Error : 64, The specified network
name is no longer available.
1999/05/20 12:12:44.09 spid27 Error : 1608, Severity: 21, State: 2
Received on Thu May 20 1999 - 15:28:09 CDT
