http://blogs.msdn.com/b/spike/archive/2009/04/16/a-transport-level-error-has-occurred-when-sending-the-request-to-the-server-provider-tcp-provider-error-0-an-existing-connection-was-forcibly-closed-by-the-remote-host.aspxIf you are reading this, you may ha

<br />How to trace connection leak<br /> <br />Problem description: (http://blogs.msdn.com/b/dataaccesstechnologies/archive/2009/10/13/connection-leak-its-symptoms-and-troubleshooting.aspx)<br />Connection leak basically happens when we open a connection t

http://blogs.msdn.com/b/adonet/archive/2010/04/18/sqlclient-default-protocol-order.aspxA while ago, someone came to me with a very interesting problem:basically, his .NET application was taking more than a minute to open aconnection. After a quick look

http://blogs.msdn.com/b/sql_protocols/archive/2008/05/20/connectivity-troubleshooting-in-sql-server-2008-with-the-connectivity-ring-buffer.aspxSQL Server 2008 contains a new feature designed to help troubleshoot particularly tricky connectivity problems. T

<br />http://blogs.msdn.com/b/bindeshv/archive/2008/03/02/indications-that-we-are-leaking-connections.aspx<br />We get a lot of queries from developers around the following error while they are using ADO.NET<br />"Timeoutexpired. The timeout period elaps

The relationship between Connection pool and connection stringConnection pool and connection string go hand in hand. Every connection pool is associated with a distinct connection string and that too, it is specific to the application. In turn, what it mea

<br />Solution 1 : http://cnych.ifastnet.com/69.html<br />最近在做数据库课程设计的时候,需要写一个还原数据库的代码，但完成后却遇到一个随机发生的异常:”A transport-levelerror has occurred when sending the request to theserver…”,异常被抛出，而且第二次点击还原的时候就没有抛出该异常了，该怎么解决呢？<br />有问题,百度/Google一下.终于找到了问题的真正原因

<br />http://www.diranieh.com/DataAccessPatterns/ResouceRetryer.htmPurpose<br />Automatically retries operations whose failure is expected under certaindefined conditions. This pattern enables fault-tolerance for data accessoperations.Scenario<br />Whe

<br />http://support.microsoft.com/?kbid=942861<br /><br />Problem:<br />Consider the following scenario. A server is running Windows Server 2003 and Microsoft SQL Server. You have an application that connects to SQL Server by using TCP/IP. In this scenari

SQL Server 2005 connectivity error messages Tag：版权声明：转载时请以超链接形式标明文章原始出处和作者信息及本声明http://milinda.blogbus.com/logs/32681728.htmlOne of the more visible changes we made in connectivity spacefor SQL Server 2005 was enhancing error messages reported to the

http://www.west-wind.com/weblog/posts/9024.aspxFirst the .NET CLR Data counters don’t work. I can’t add those even to Performance Manager. I've used these perf counters since .NET 1.x and I suspect these are no longer used for .NET 2.0. So the following is

http://www.codeproject.com/KB/dotnet/ADONET_ConnectionPooling.aspxConnectionpooling can increase the performance of any application by using activeconnections of the pool for consecutive requests, rather than creatinga new connection each time.And at

Client (TCP and Named Pipe) Connection Pooling <br />http://kennyw.com/indigo/181<br />The way connection pooling works on the client is as follows:When you open a channel we will first look for a connection in our pool. This lookup is performed based on I