asp.net - The timeout period elapsed prior to obtaining a connection from the pool -

I get this error every few days I will not be able to see the error for a few days, so let me 20 or so Will get panic in a minute or so.

I am completely throwing my code so that I am using this basic setup for access to my DB.

  Try {myConnection.Open (); MySqlDataAdapter.Fill (myDataTable); MyConnection.Close (); } Hold (exception mistake) {if (myConnection.State! = ConnectionState.Closed) myConnection.Close (); Throwing; }  

The way I understand it, he should execute my questions and immediately return the connection to the pool but if something goes wrong in the query, Turn off, then my connection to the error-up, which eventually gets trapped at the application level and logs and emails me an error.

Even during my code, I'm still using this issue, what can I do to diagnose the root cause of this issue?

The issue is the number of pool connections you can be in the pool.

In your connection string, you can add the "maximum pool size = 100" attribute to increase the size of your pool. Although it seems that you are running a large number of concurrent SQL queries, all of which have been running for a long time. Perhaps you should see ways to reduce any connection or run sequentially through a connection.