SQL Server Performance

The client was unable to reuse a session with SPID #, which had been reset for conection pooling.

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jul 14, 2009.

  1. Anonymous New Member

    At first I thought it is the problem with the client connection and connection pooling settings, to dig out on the issue I have obtained further information from the system DBAs to findout that SQL Server instance (2005 &amp; 2008) having web server farm with an identical connection string having ADO connection pooling between them. Occassionally they had issues with 2008 server but it is persisitent 2005 instance whereby the performance on that instance would go down to zero and unresponsive at...(<a href="http://sqlserver-qa.net/blogs/x64/archive/2009/07/14/5811.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=5811" width="1" height="1">

Share This Page