SQL ALert-Fatal Error in Current Process

Question

Guys,

Good day.

Can anyone explain what the message below means?

"The client was unable to reuse a session with SPID 615, 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."

This past few I've also been receiving mails from the Buffer Cache Hit ratio Alert. I know that this is basically a data retrieval problem but the one above, I could not understand where its coming from.

My SQL server 2008 std had been running for a year now.This is the third time I've been alerted to this kind of problem.

Thank you in advance.

 



---

****rasserusenpai****

Answer 1

Hi Rasserusenpai,
>>"The client was unable to reuse a session with SPID 615, 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."

According to the error message,which might be caused by many things. It basically means the SPID is not ready for a new connection, so it is refused.

Meanwhile these two articles addressing this type of issue may helpful to you, please refer to the
1. http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=468478
2. http://blogs.msdn.com/b/psssql/archive/2010/08/03/how-it-works-error-18056-the-client-was-unable-to-reuse-a-session-with-spid-which-had-been-reset-for-connection-pooling.aspx

If it does not work for you, please post error logs for further troubleshooting.

---

Regards, Amber zhang