Loading

Maximum pool size

james kim

10y1.1k

i have hosted asp.net sql server application on iis. Each time multi-user post batch data same time. The system throws error max pool reached. I have closed all connections. What is the problem?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth10y ago
Hi,

Increase Maximum pool size in your webconfig.

Check my tech blog reference :

https://rajeeshmenoth.wordpress.com/2014/06/10/timeout-expired-and-the-timeout-period-elapsed-prior-to-obtaining-a-connection-from-the-pool/
0
Manas Mohapatra10y ago
Hi James,

Please cross verify that you are closing the Database always. Because issue due to less no of connection pool available in ASP.NET pipeline.

Secondly you can increase max no pool in Web.config connection string:

Max Pool Size=200;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

https://msdn.microsoft.com/en-us/library/8xx3tyca(v=vs.110).aspx
0