[Zope] Counting threads

[Jaroslav Lukesh]

----- Original Message ----- 
From: "Peter Bengtsson" <peter at fry-it.com>


> On 22/01/2008, Dieter Maurer <dieter at handshake.de> 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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pool_size.txt
Type: application/octet-stream
Size: 3465 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zope/attachments/20080123/a19734a3/pool_size.obj