最近计算机系统很不稳定，经常出现网络故障，此时服务器会报错，各工作站全部处于等待状态，一段时间之后（越长越短）会自动正常。由于系统对实时要求较高，所以给我造成了很大的压力，望各位高手尽力指点，不胜感谢！现将服务器事件管理器中的错误传上。
1） 事件ID：17060
来源：MSSQLServer
类型：错误
种类：Server
描述：
Error:1608, Severity:21 , state:2
A network error was encountered while sending results to the front end.Check the SQL Server errorlog for more infomation.
- 事件ID: 17058
来源：MSSQLServer
类型：信息
种类：ODS
描述：
Error:17824, Severity: 10,state:0
Unable to write to ListenOn connection '1433',loginname 'eddbo', hostname ''. Os Error:64, 指定的网络名不再可用.
---------------------------------------------------------------
below information from MSDN,I think this could be help to you.
good luck!
Error 17824 "Unable to write to ListenOn connection" indicates that problems have occurred while SQL Server attempted to write to a client connection and failed. These communication problems may be caused by network problems, or if the client computer has stopped responding or been restarted. For more information regarding other communication errors, please refer to the following article in the Microsoft Knowledge Base:
Q109787 : INF: SQL Communication Errors 17832, 17824, 1608, 232, and 109
Error 17824 does not always indicate a network problem. The following are the most common situations under which the error 17824 is generated, along with the corresponding troubleshooting procedures.
This error may occur if the users are restarting their client computers if the application seems have stopped responding, so make sure they don't do that. It may be that the server is taking a longer time to process a long query. Once the client workstation is restarted, the connections are broken ungracefully. Later SQL Server tries to respond to the connection that has been dropped, and logs the message 17824.
The network may be unstable; make sure it is stable. You can check this by attempting to copy large files between the computer running Windows NT Server and the client computer. If this test fails, then you are running into problems with the physical network. Because the above errors indicate a potential network issue, it is recommended that you update the server, both Windows NT Server and SQL Server, to the latest service packs. Please check the knowledge base articles for more information on how to obtain the latest service packs for the Windows NT Server operating system and SQL Server. It is also recommended that you update the client components such as DB-Library, the ODBC driver, and network library to the latest DLLs. In case of client computers running 16-bit Windows 3.1 or Windows for Workgroups on a Novell network, it is necessary to obtain and install the latest MS-DOS and Windows drivers from Novell.
Error 17824 "Unable to write to ListenOn connection" may be a consequence of other errors that caused the connection to drop. Check the error logs for other errors within the same time frame as the 17824 error. If you find other errors, refer to SQL Server Books Online and the Microsoft Knowledge Base for more information on these errors.
Use sp_configure or the SQL Server Enterprise Manager to check the Priority Boost and the SMP Concurrency configuration settings. Make sure that these two configuration options are set to the default settings, because deviating from the default settings may cause error 17824 under some conditions.
For more information on why these settings may generate error 17824, please refer to the following article in the Microsoft Knowledge Base:
Q111405 : INF: SQL Server and Windows NT Thread Scheduling.
The error 17824 may be generated due to application problems. One major cause is running into a lock or block situation. In this case, a process holds a lock on a page or a table, and that lock is not released right away, due to an uncommitted transaction or a long query. This may cause all other processes requesting the same table to be blocked, and the client application to seem to stop responding. If the user then either uses 'End Task' to close the application or restarts the workstation, you may receive error 17824 on the server.
To find out if the application is causing a lock or block problem on the server, use the sp_who and sp_lock stored procedures when the client computers seem to stop responding or when the error 17824 starts to appear in the SQL Server error logs. If the client workstation has stopped responding, open a command-line ISQL connection on the server itself using the local pipe, and use these stored procedures to check for a blocking situation.
For more information on detecting and resolving blocking problems, please refer to the following article in the Microsoft Knowledge Base:
Q162361 : INF: Understanding and Resolving SQL Server Blocking Problems
If you have checked all of the above points and the problem still persists, contact SQL Server support for further troubleshooting assistance.
---------------------------------------------------------------
第一错误是系统错误，
严重级别 21：数据库 (dbid) 进程中的 SQL Server 严重错误
这些消息表明遇到了影响当前数据库中所有进程的问题；但数据库本身损坏的可能性不大。