i have problem connection pooling on sql server 2008 r2 environment (os windows server 2008 r2 x64). periodically seeing in sql server error logs:
event id: 18056
description: client unable reuse session spid 157, had been reset connection pooling. failure id 29. error may have been caused earlier operation failing. check error logs failed operations before error message.
sql 2008 , sql 2008 r2 failure id : redologinexception, 29
we have migrated sql server 2008 r2 cu4, running on windows server 2008 r2, , issue continues. sql server having problem communicating 1 of domain controllers when happens.
when happens, sql server agent produces these errors:
[382] logon server 'dbinst01\dbinst01' failed (jobmanager) [382] logon server 'dbinst01\dbinst01' failed (connupdatejobactivity_nextscheduledrundate) [298] sqlserver error: 258, unable complete login process due delay in prelogin response [sqlstate 08001] [298] sqlserver error: 258, tcp provider: timeout error [258]. [sqlstate 08001] we checked error logs previous errors error can see error in log files. may cause error , how can investigate that?
please check:
2543687 fix: errors when client application sends attention signal sql server 2008 or sql server 2008 r2 http://support.microsoft.com/kb/2543687/en-us
the fix 2008 r2 rtm in cu 14 2703280 cumulative update package 14 sql server 2008 r2
Comments
Post a Comment