Re: MaxPoolSize - Recommendations

It would look rather that the connection string is not always the same....
Have you checked in SQL Server under which account those connections are
done ?

Also if you look at the max poll size (100 if I remember) and the default
pool size (don't remember) it's likely that :
- either those settings are increased for some reason by the application
- either they create mutliple pools

Anyway the idea is when you are above the default pool size you should have
less connections than users when here you have more connections than
users...


Good luck.

--
Patrice

"hrabia" <hrabia@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message de news:
89F39CE0-350D-48D4-AA22-F0B3796E364C@xxxxxxxxxxxxxxxx
I'm testing now a third part web application (ASP.NET 2.0, MS SQL Server
2005) that seems to work properly but creates up to 400 (sic!) connections
for average 80 concurrent users. The application is pretty
straightforward:
login, some grids with data and that's it. In my opinion (I'm an
experienced
.NET architect :) 10 concurrent connection (in a peak) should be enough
but
400 (in the pool) are very strange for me. I've informed the vendor that
the
current situations is not acceptable for me but I've got an answer that
Microsoft doesn't have any recommendations concerning "max pool size"
value,
so it can be set even to the maximum value of connections that are allowed
by
MS SQL Server (~ 32.000!). I've tried to find any official recommendations
in
msdn but I've found only sentences like "application dependent", "sense,
rational value" and so on. I have to protect my department from an
application with wrong architecture but I can't find any strong-based
arguments. Help :)!


.

Relevant Pages

  • Connection pooling issue - Timeout expired.
    ... I have a .NET application that uses SQL server. ... connection from the pool. ... connections were in use and max pool size was reached" ... why arent these sleeping proecsses processes being reused since all ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: gdb help: debugging a segfault in boost::shared_ptr
    ... I am developing a database connectivity plugin for the Remedy Action ... I've developed a database pool for the plugin so the time ... The pool will also check if the connections are ... Thread-safe means that shared_ptr handle ...
    (comp.os.linux.development.apps)
  • Re: determining max pool size
    ... the larger the pool size, the more requests can be server. ... 500 open connections to SQL server I awfully lot.... ... close the connection without even executing the sql statement). ...
    (microsoft.public.dotnet.framework.aspnet)
  • JNDI Connection Pool issue
    ... I have found something strange with the jdk jndi connection pool. ... If you do not iterate over all the results returned by the query, ... private static HashMap connections; ... SearchResult searchResult= ...
    (comp.lang.java.programmer)
  • Re: MaxPoolSize - Recommendations
    ... Perhaps the pool is not leaking, ... using connections efficiently. ... for average 80 concurrent users. ... Microsoft doesn't have any recommendations concerning "max pool size" ...
    (microsoft.public.dotnet.framework.adonet)
Loading