Re: MaxPoolSize - Recommendations

Not necessarily each tme but sometimes if for example 4 parts in the app
have each their own settings or do something swith the connection string...

--

"William (Bill) Vaughn" <billvaRemoveThis@xxxxxxxxxx> a écrit dans le
message de news: e6nyLGezGHA.1300@xxxxxxxxxxxxxxxxxxxxxxx
I'm with Mr. Beamer. I've heard of very heavily accessed sites having 25
connections in the pool. 400 is nuts. Patrice, I agree, there is some
serious problem here. Perhaps the pool is not leaking, but it's clearly
not using connections efficiently. I would chart the use of the pool via
the performance counters and see if the number stabilizes at 400 or
continues to rise--it might very well be leaking--slowly. For example, if
a query generates an exception every 1000 operations and the exception
handler bypasses the Close, it could leak slowly and not overflow for
days.

Ah, if the ConnectionString changed, there would be 400 pools not 400
connections in the pool.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________

"Patrice" <scribe@xxxxxxxx> wrote in message
news:u89naHdzGHA.1300@xxxxxxxxxxxxxxxxxxxxxxx
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

  • 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)
  • Re: RSX-11M-Plus Pool questions
    ... The fact that these 4 PDP-11 systems are still running after 30 ... connections along with 1 VAX 4000 and several DECServer Terminal servers). ... I have read all the RSX documentation I can find relating to pool ... I think I have a good grasp on Secondary pool. ...
    (comp.os.vms)