Post reply

The client was unable to reuse a session with SPID 157, which had been reset for connection pooling. The failure ID is 29.

  • October 18, 2012 at 1:53 pm

    #265802

    I am seeing more of these errors since we added the LYNC databases to our one Cluster instance. This instance also runs other large databases such as Operations Manager and Foglight. Is there a setting I should change in the SQL Server System settings... or a log that may give me more insight as to a resolution?

    Thanks!

    Charlie

  • October 19, 2012 at 7:04 pm

    #1551083

    It might be this:

    http://support.microsoft.com/kb/2543687

    This bug is exposed when sql server resets connections after clients time out. so, apply the culm update to fix the issue, but it won't help the fact that you're still getting timeouts.

  • October 26, 2012 at 4:53 pm

    #1553447

    here is the best microsoft connect item on the issue http://connect.microsoft.com/SQLServer/feedback/details/540092/sql-server-2008-sp1-cu6-periodically-does-not-accept-connections

    im guessing the event id is 18056? if so the above will have allot of information. we are dealing with this same error on one of our production boxes. we think we have the fix but it will be a little while while we wait for some server parts to come in before we can really find out.

    also from my reading on the CU is it just stops the ATTENTION event and not the underlying issue.

    you can also go to this link http://blogs.msdn.com/b/psssql/archive/2010/05/05/error-18056-can-be-unwanted-noise-in-certain-scenarios.aspx which has some useful information on the issue.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply