SQL 2008 R2 SP2 event id 18056

Posted on 2013-10-17
Medium Priority
Last Modified: 2013-11-02
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
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.
Question by:cbsykes
  • 2
LVL 15

Expert Comment

ID: 39583601

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).



Accepted Solution

cbsykes earned 0 total points
ID: 39605504
I updated to SP2 CU1 and problem seems resolved so far...

Author Closing Comment

ID: 39618526
Finally resolved after lots of research...

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question