sql-server-2008-r2 - SQL Server 2008 R2 定期不接受连接

Question

我在 Sql Server 2008 R2 环境(操作系统是 Windows Server 2008 R2 X64)上遇到连接池问题。我定期在 Sql Server 错误日志中看到这个:

Event ID: 18056

Description: The client was unableto reuse a session with SPID 157,which had been reset for connectionpooling. The failure ID is 29. Thiserror may have been caused by anearlier operation failing. Check theerror logs for failed operationsimmediately before this error message.

SQL 2008 and SQL 2008 R2 failure id is : RedoLoginException, 29

我们已迁移到在 Windows Server 2008 R2 上运行的 SQL Server 2008 R2 CU4，但问题仍然存在。发生这种情况时，SQL Server 与其中一个域 Controller 的通信出现问题。
发生这种情况时，SQL Server 代理会产生以下错误:

[382] Logon to server 'DBINST01\DBINST01' failed (JobManager)
[382] Logon to server 'DBINST01\DBINST01' failed (ConnUpdateJobActivity_NextScheduledRunDate) 
[298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
[298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]

我们检查了之前错误的错误日志，但我们能看到的唯一错误是日志文件中的这个错误。什么可能导致此错误，我该如何调查？

Answer 1

请检查:

2543687 修复:客户端应用程序向 SQL Server 2008 或 SQL Server 2008 R2 发送注意信号时出错
http://support.microsoft.com/kb/2543687/EN-US

2008 R2 RTM 的修复在 CU 14 中
2703280 SQL Server 2008 R2 的累积更新包 14