SQL ALert-Fatal Error in Current Process


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



    Saturday, December 03, 2011 8:15 AM