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.