Testing SQL's performance using Jmeter is quite simple , below steps would help for the same.
I have used Oracle 11g for testing purpose.
1) Create a JDBC request Sampler on Jmeter thead group
JDBC Request -> Provide Unique variable name ( this variable name will be refereed by JDBC connection config ) and Select a SQL Type (update or insert , etc...).
2) Create a JDBC Connection Configuration as Config element.
Make sure you you provide correct Driver class and Database URL , below are for Oracle 11g.
DataBase URL-> jdbc:oracle:thin:@Hostname:1521:InstanceName
JDBC Driver Class -> oracle.jdbc.driver.OracleDriver
3) Add Response Assertion for validate the correct response of the SQL output ( check point on Load runner (web_reg_find)).
4) Add Listeners based on your needs like summary reports , Response time graphs , etc...
Have a look at below screen for JDBC Configurations.
I have used Oracle 11g for testing purpose.
1) Create a JDBC request Sampler on Jmeter thead group
JDBC Request -> Provide Unique variable name ( this variable name will be refereed by JDBC connection config ) and Select a SQL Type (update or insert , etc...).
2) Create a JDBC Connection Configuration as Config element.
Make sure you you provide correct Driver class and Database URL , below are for Oracle 11g.
DataBase URL-> jdbc:oracle:thin:@Hostname:1521:InstanceName
JDBC Driver Class -> oracle.jdbc.driver.OracleDriver
3) Add Response Assertion for validate the correct response of the SQL output ( check point on Load runner (web_reg_find)).
4) Add Listeners based on your needs like summary reports , Response time graphs , etc...
Have a look at below screen for JDBC Configurations.
5) Run the thread group after setting the number of users ( threads).
If you have access to OEM ( Oracle enterprise manager console) try to monitor the SQL's after you run the jmeter thread group so that you can analyze how the SQL is performing.
Hope this helps :)
Hi! Thanks for sharing your thoughts. Well, the automated testing tools actually save your time and energy. The testing tools will do the work for them when it comes to the testing process so that they can do other work as well.Performance testing services is a highly specialized field of testing.
ReplyDelete