We already have that data available. The increase in end to end response times is not matched identically by an increase in time spent running queries. ( There is some increase in db time, but not as much as is seen end to end )
--------- Original Message -------- From: JMeter Users List <[email protected]> To: JMeter Users List <[email protected]> Subject: Re: Time spent where? Date: 28/01/08 14:58 > what I would do is added some simple code to time how long the queries take > and write that to a file. > > Back when I worked for Superpages.com, we had all sorts of performance > logging, so that we could generate reports every night. In my case, we had > service level agreements, so we had to log extensively and make sure > response time were within the requirements. > > peter > > On Jan 28, 2008 9:23 AM, sebb wrote: > > > On 28/01/2008, Lists wrote: > > > Hi, > > > > > > I've posted about this before, but got some more info now. > > > > > > We have a standard apache -> tomcat -> oracle system. In the db we can > > > access the total time spent in tomcat and oracle. By analysing the > > apache > > > logs (modjk gives you an elapsed time) we can log the time spent in > > apache, > > > tomcat and oracle. > > > > > > And then of course jmeter gives us the overall end to end response > > times. > > > > > > The problem i have is that at higher loads, the gap of response times > > > reported by jmeter grows much faster than it does when reported at the > > > apache layer. So i thought this was caused by a busy jmeter server. > > > > > > So i ran 2 jmeters on 2 separate servers independantly (At half load). > > > Unfortunately the gap remains. > > > > > > Is this a usual scenario that people see at high loads? could the > > figures > > > being reported be lieing to me? The DB server is under load at this > > point > > > but none of the other servers seem stressed. I'm a bit stuck in how to > > > debug this further? > > > > > > > How much longer? A few percent or much more? > > > > Are all samples affected? > > > > Does the additional time depend on the sample size? > > > > Note that the elapsed time will necessarily be longer than the apache > > log time; the JMeter latency should be closer to the apache log > > timings. > > > > Are you using any functions in the samplers? Function execution is > > single-threaded. > > > > > Thanks, > > > Dan > > > > > > ________________________________________________ > > > Message sent using UebiMiau 2.7.10 > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > ________________________________________________ Message sent using UebiMiau 2.7.10 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

