RE: Performance degradation under load

2005-12-16 Thread JT Neville
Sent: Friday, December 16, 2005 8:36 AM To: Tomcat Users List Subject: Re: Performance degradation under load Marc- What version of JVM? what version tomcat? Martin- - Original Message - From: "Marc Richards" <[EMAIL PROTECTED]> To: "Tomcat Users List" ; "Mart

Re: Performance degradation under load

2005-12-16 Thread Martin Gainty
Marc- What version of JVM? what version tomcat? Martin- - Original Message - From: "Marc Richards" <[EMAIL PROTECTED]> To: "Tomcat Users List" ; "Martin Gainty" <[EMAIL PROTECTED]> Sent: Friday, December 16, 2005 11:02 AM Subject: Re: Performa

Re: Performance degradation under load

2005-12-16 Thread Peter Lin
? > > Viel Gluck! > > Martin- > > > > - Original Message - > > From: "Jess Holle" <[EMAIL PROTECTED]> > > To: "Tomcat Users List" > > Sent: Friday, December 16, 2005 10:29 AM > > Subject: Re: Performance degradation u

Re: Performance degradation under load

2005-12-16 Thread Marc Richards
racle..but am > hard pressed for > specific details on implementing performance tuning > with DB2 > > Anyone else? > Viel Gluck! > Martin- > > - Original Message - > From: "Jess Holle" <[EMAIL PROTECTED]> > To: "Tomcat Users Li

Re: Performance degradation under load

2005-12-16 Thread Marc Richards
Yes, we do joins where appropriate and I guess I should clarify the inaccuracy of my initial statement - there is one connection per request (for each individual sql), rather then for each unique table. -marc --- Jess Holle <[EMAIL PROTECTED]> wrote: > Caldarale, Charles R wrote: > > >This real

Re: Performance degradation under load

2005-12-16 Thread Martin Gainty
- Original Message - From: "Jess Holle" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Friday, December 16, 2005 10:29 AM Subject: Re: Performance degradation under load Caldarale, Charles R wrote: This really sounds like you're not using connection poo

Re: Performance degradation under load

2005-12-16 Thread Jess Holle
Caldarale, Charles R wrote: This really sounds like you're not using connection pooling, but instead are opening a new connection for each request. How many do you have configured in the pool? If it's less than the number you see with netstat, that would be another indication that your app is

Re: Performance degradation under load

2005-12-16 Thread Martin Gainty
ist" ; "Martin Gainty" <[EMAIL PROTECTED]> Sent: Thursday, December 15, 2005 11:29 PM Subject: Re: Performance degradation under load While you are running how many database connections does your database report having open? You might want to use the tomcat manager status

Antwort: RE: Performance degradation under load

2005-12-16 Thread Jan Behrens
Hi Marc, it still sounds like it could be a connection pool issue to me. Which of the available connection pools are you using and how exactly have you set it up in your tomcat config? Maybe we can see something in there. Cheers, Jan Jan Behrens OFFIS FuE-Bereich Betriebliches Informationsman

Re: Performance degradation under load

2005-12-15 Thread Mark Thomas
When starting a new thread (ie sending a message to the list about a new topic) please do not reply to an existing message and change the subject line. To many of the list archiving services and mail clients used by list subscribers this makes your new message appear as part of the old thread. Thi

Re: Performance degradation under load

2005-12-15 Thread Bruno Georges
Subject: Re: Performance degradation under load I hear YourKit is good. I've mainly used OptimizeIt the last 4 years and it works well for me. something odd is definitely happening. at this point, it sounds you've exhausted all the obvious and not so obvious options, so it's probably m

Re: Performance degradation under load

2005-12-15 Thread Marc Richards
Thanks, I'll check into that. Maybe I can get an eval license right away and update if I find anything. Thanks, -marc --- Peter Lin <[EMAIL PROTECTED]> wrote: > I hear YourKit is good. I've mainly used OptimizeIt > the last 4 years and it > works well for me. > > something odd is definitely

Re: Performance degradation under load

2005-12-15 Thread Peter Lin
I hear YourKit is good. I've mainly used OptimizeIt the last 4 years and it works well for me. something odd is definitely happening. at this point, it sounds you've exhausted all the obvious and not so obvious options, so it's probably most fruitful to profile it. peter On 12/16/05, Marc Ric

Re: Performance degradation under load

2005-12-15 Thread Marc Richards
No, the firewall is in front of the load balancers and the servers are separated from the network by the dmz. At some point there will be a reverse proxy in there somewhere (they tell me - I'm not a network engineer), but at the moment it's not open to the internet so I just have it directly opene

RE: Performance degradation under load

2005-12-15 Thread Marc Richards
Yes, I agree - I thought that too, but didn't really know what I was suppose to be seeing. I have Tomcat configured to open 500 (because I was mucking around trying to make it work, not because I think that's the right setting) connections on startup and maintain a minimum of 100 idle at any time.

Re: Performance degradation under load

2005-12-15 Thread Peter Lin
sounds like you have a big big mainframe, so I also doubt the database server is an issue. Is there any firewall between tomcat and the database server? it could be the firewall is limiting the number of connections and therefore forcing the db connection pool to wait longer than it should to crea

Re: Performance degradation under load

2005-12-15 Thread Marc Richards
No, the db is actually our world-wide enterprise server. It's got plenty of capacity for handling many hundreds of thousands of daily transactions. When I'm pounding the web app I literally can not even see my activity on the machine and the disk arms are all calm. It's made for tougher stuff th

RE: Performance degradation under load

2005-12-15 Thread Caldarale, Charles R
> From: "Marc Richards" <[EMAIL PROTECTED]> > Subject: Performance degradation under load > > Tomcat is handling connection pooling to our iSeries > database server (db2, jdbc), but I'm not sure it's > working correctly because when I do netstat I see > several thousand db connections sitting at TI

Re: Performance degradation under load

2005-12-15 Thread Dov Rosenberg
While you are running how many database connections does your database report having open? You might want to use the tomcat manager status app to see how many threads you are using, how many sessions are being created, etc. Lots of sessions can eat up memory as well if they are not being killed off