C# .NET - change max pool size - Asked By Dom Afonso on 17-Jun-12 02:52 PM

How to change the maximum pool size in asp.net?
dipa ahuja replied to Dom Afonso on 17-Jun-12 05:20 PM
you can add this in the connection string this way:

Server=(local); ........; Database=Northwind; Max Pool Size=45; Min Pool Size=10 
Default value of Max Pool size is 100. You can set it to a higher number also so far as performance of the server is not a issue..
aneesa replied to Dom Afonso on 18-Jun-12 12:02 AM
by default pool size is 100.So change it to some larger value in your connection string in web.config file or wherever it is. To change it insert MAX POOL SIZE=300; in your connection string.

Jitendra Faye replied to Dom Afonso on 18-Jun-12 01:18 AM
For changing Max pool size, you need to specify in web.config file while defining Connection string.

Try like this-

connectionString="Data Source=serverName;Initial
    Catalog=Northwind;Persist Security Info=True;User
    ID=userName;Password=password  ; Max Pool Size=60;"

Try this and let me know.