How to set connection pool to 100 in sql server 2005 instance

Question

How to set connection pool to 100 in sql server 2005 instance

Answer 1

Connection pooling is a client setting and is already at 100 per appdomain:

Connections are added to the pool as needed, up to the maximum pool size specified (100 is the default).

Answer 2

If you want to change it, you need to do this on the client, as Remus already mentioned. The client is creating the connection pool.

You can specify the connection pooling properties in your connection string that you use to connect to SQL Server. The most important properties are:

• Pooling : which can be true or false - use pooling or not
• MinPoolSize : minimum size of connection pool; default is 10
• MaxPoolSize : maximum size of connection pool; default is 100

So if you want to enable pooling and have min. 20, max. 250 connections, you could use this connection string:

server=MyServer;database=MyDatabase;Pooling=True;MinPoolSize=25;MaxPoolSize=250

For more details, see the MSDN docs or check out the Connection Strings web site.

Marc