----- 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.
pool_size.txt
Description: Binary data
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )