none
Connection pool size issue

    Question

  • Hi,

    I have a question about ADO.Net's way of handling connections. My server app uses ADO.Net to connect to SQL Server to server clients' calls. Some times I get error message that says that I may run out of connections in the pool and I should consider exband the size of the connection pool (not the exact words). I am a little confused by this error because, to my knowlege, the connection pooling is by defualt set to a certain size. If all the connections in the pool are taken and when a new connection is requested, ADO will automaticly increase the pool size, isn't it? If so, why do I get the error message? If not, what should I do to avoid this kind of error?

    Please help!

    Thanks a million.

    Feng

    Thursday, March 16, 2006 4:31 PM

Answers

  • The default maximum connection pool size is 100. It won't be increased automatically. You can only set it by change the "Max Pool Size" parameter in the connection string.

    You can use performance monitor to watch the NumberOfPooledConnections.

    Thursday, March 16, 2006 5:34 PM

All replies