cbsykes
asked on
SQL 2008 R2 SP2 event id 18056
Hi,
Trying to troubleshoot errors I have found just recently in my app log on my SQL 2008 R2 SP2 server. See the error below. I have read lots of posts online concerning this error but I haven't found any resolution. Can anyone shed some light on this issue? When I first found this error yesterday I was on SP1 and I have since upgraded to SP2, however the errors still occur. My server resources are running normal when these events occur. When these events are occurring some users are reporting very slow login times for our SQL app and very slow while working in the app. Thanks for your help.
Log Name: Application
Source: MSSQL$DATABASE
Date: 10/17/2013 8:10:39 AM
Event ID: 18056
Task Category: Server
Level: Error
Keywords: Classic
User: N/A
Computer: server2.domain.com
Description:
The client was unable to reuse a session with SPID 81, which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
Trying to troubleshoot errors I have found just recently in my app log on my SQL 2008 R2 SP2 server. See the error below. I have read lots of posts online concerning this error but I haven't found any resolution. Can anyone shed some light on this issue? When I first found this error yesterday I was on SP1 and I have since upgraded to SP2, however the errors still occur. My server resources are running normal when these events occur. When these events are occurring some users are reporting very slow login times for our SQL app and very slow while working in the app. Thanks for your help.
Log Name: Application
Source: MSSQL$DATABASE
Date: 10/17/2013 8:10:39 AM
Event ID: 18056
Task Category: Server
Level: Error
Keywords: Classic
User: N/A
Computer: server2.domain.com
Description:
The client was unable to reuse a session with SPID 81, which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Finally resolved after lots of research...
You're experiencing kind of generic type of this error, please try to find some info in sys.dm_os_ring_buffers DMV (use following link for queries).
http://mssqlwiki.com/2013/03/29/inside-sys-dm_os_ring_buffers/
Regards,
Daniel