----- Original Message ----- From: "Peter Bengtsson" <[EMAIL PROTECTED]>

On 22/01/2008, Dieter Maurer <[EMAIL PROTECTED]> wrote:
Peter Bengtsson wrote at 2008-1-22 15:23 +0000:
>Perhaps I'm wrong but I suspect that a Zope I'm running is dying because
>of running out of threads.

I'm just not certain if it's this. It seems highly related to MS SQL
connections but I could be wrong. The strange thing is, restarting the
MS SQL server might be (we're not certain) a solution to get Zope
responding again.

My theory was that the threads get too attached to a network service
that doesn't time out or raise an error.

You have absolutelly true!

I was the same problems in past. I was make up to 150 threads in some rare cases, but 50..100 in general if I use MSSQL. It was with Zope 2.5.1, with modern zope, see attachment about pool_size.

Now I use 80 threads and 60 pool_size and my Zope+MSSQL is fine. MSSQL hits in day peaks 100% CPU load (about hour, two) , but it is not my business. But my business is functional zope webs which eats a lot of RAM due caching policy - about 5..10 times more than before... So you have been pointed and warned ;-)

Best Regards, JL.

Attachment: pool_size.txt
Description: Binary data

Zope maillist  -  Zope@zope.org
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to