Karsten, If your datasource interface is JDBC, then try fetching all the queries fired during the load test from the database trace logs and fire those SQL queries directly to the database tier using Jmeter's JDBC sampler. The reason why I insist people to follow this strip down approach is because it allows you to focus on the layer which has the problem, which is obviously better. Plus, the load on the database is more when you fire queries directly on it, this can help you identify a problem much easier.
PS: Is your database - Oracle? -Chaitanya M Bhatt http://www.performancecompetence.com 2010/7/22 Karsten Gaul <[email protected]> > Hi, > > I'm trying to figure out, why my oracle db occasionally crashes when i load > test my website using jmeter. yes, i do have some flexible queries that are > quite long. The funny thing is, as mentioned, that the db does not crash > every time i run the same test. My admin told me the machine crashed due to > excessive memory consumption. > My test plan has four thread groups with a different number of threads and > different ramp-up times whereof the longest is 5 mins. The overall amount of > threads is 790. It's kinda weird that, when the db does not crash during the > test, it hardly complains about anything. Neither is there too much load nor > are there too many sessions. > > the db server has 4 gb of ram if that's of any use. > > I hoped to get to the limits of the webapp but the db seems to be the > problem instead. > > Any ideas? > > Thanks > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
