hey chaitanya,
yeah it's an oracle db and the interface is jdbc. Fetching all the
queries might be quite hard since there really are a lot of those.
Furthermore, most of them are flexible queries that rely on the webapp
backend. I probably could just compose some but that wouldn't be the
same really.
rgds
Karsten
Am 22.07.2010 12:47, schrieb chaitanya bhatt:
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]>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
