100分求解疑难问题

[nk_maquan]

在线运行的分布式系统，DataBase和Server运行在不同的主机，DataBase为sql server2005，操作系统为windows server2003，Server的运行环境也为windows server2003，server使用C#进行开发，使用ADO.NET与数据库进行数据交互。目前的情况是server会不定期的出现如下报错（报错一），且该报错出现后就会引发后续一序列的报错，引起服务器在线人数下降。求教大家帮忙分析下原因及解决方案，不甚感激。

报错一
Event Type:	Error
Event Source:	Application
Event Category:	None
Event ID:	0
Date:		2010-10-21
Time:		11:02:13
User:		N/A
Description:
The description for Event ID ( 0 ) in Source ( Application ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 执行存储过程: SP_User_Update_BoxProgression错误信息为: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.).

报错二
Event Type:	Error
Event Source:	Application
Event Category:	None
Event ID:	0
Date:		2010-10-21
Time:		11:02:14
User:		N/A
Description:
The description for Event ID ( 0 ) in Source ( Application ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 打开数据库连接错误:Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding..

[wuyq11]

数据库服务器负载过大
链接超时
连接后,长时间没有做任何动作
双机容错

[hao1hao2hao3]

数据的传输存在问题，检查看看（在命令行中执行ping ipAddress -t）各个服务器之间会不会有网络问题。

[nk_maquan]

谢谢楼上两位，出现问题的时候ping服务器主机是连接正常的，而且是偶发性的故障，错误日志总是最先出现一个传输层错误，然后才会出现连接数据库超时之类的错误。