How to find unclosed connection? Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding?

The error you are providing doesn't really point to a connection that is left open; it is more likely that there is a query that is taking longer than the application expects. You can increase the time it waits for a response, and you could use Sql to find which queries are the most taxing.

If your using C#, the biggest cause of this problem is DataReaders and returning these objects to the upper layers. Most likely some client class is not closing the DataReader it received from your DAL class, leaving the connection open/locked for who knows how long. Track down the DataReaders you're returning and make sure your client classes are closing/disposing of them properly.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions