January 3, 2012 at 2:13 pm
Hi, I'm getthing this error everal times each day.
The client was unable to reuse a session with SPID <id is here>, 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.
SQL Server 2008 SP3
CU2 for SP3 has this listed as an error that was fixed but applying the CU did not fix the problem.
Does anyone know of a solution?
Thanks,
Howard
January 6, 2012 at 12:17 pm
The problem was that the cluster nics had become unteamed so there was a significant amount of packet loss. When fixed, the errors went away.
January 6, 2012 at 1:08 pm
Thank you for the feedback !
Others will benefit from it.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply