Set Maximum Pool Size in web.config

B

Bei

I would like to allow more connection to SQL servers from the web
application.

Do you know what is the code to set maximum pool size in web.config file?

Thanks
 
G

Guest

A sample connection string for SQL Server:
"Data Source=(local);Initial Catalog=pubs;User ID=sa;Password=;Max Pool Size=75;Min Pool Size=5;"

Tiendq,
(e-mail address removed)
 
G

Guest

You can set that in SQL Connection String...e.g

"Server=(local); ..........; Database=Northwind; Max Pool Size=45; Min Pool Size=10

When a connection is opened and a pool is created, multiple connections are added to the pool to bring the connection count to the configured minimum level. Connections can be subsequently added to the pool up to the configured maximum pool count. When the maximum count is reached, new requests to open a connection are queued for a configurable duration.

Avneesh Kuma
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,906
Latest member
SkinfixSkintag

Latest Threads

Top