Tuesday, October 18, 2016

HPE Loadrunner vs Apache Jmeter

Apache JMeter:

Apache JMeter is an open source performance & load testing tool, which is developed and maintained by Apache. JMeter is mostly used for load testing of web services and web application servers. Testing teams are also known to use it for functional testing of web services. Following are some key points about JMeter.
a) Open-source: JMeter is open source and available free of cost; therefore many software teams prefer to use it for its cost effectiveness.
b) Components: JMeter has test elements like Thread Group, Samplers, Listeners, Pre & Post processors. Other than that, there are tons of third party free/commercial tools which can be integrated with JMeter to enhance its capabilities like JMeter Extras plugin, BlazeMeter, UBIK load pack and Loadosophia etc.
c) Platform compatibility: JMeter is compatible with Windows, Mac and all UNIX based systems.
d) Supported applications: JMeter primarily supports Java & Java server page applications. But it is also equally good to test server applications / web services / databases developed in other technologies. JMeter can also be used for load testing of mobile application server-side.
e) Reporting: In open source/free tools category, JMeter is one of most mature tools as its first was version was released in 1998 and since then there have been many upgrades to it. Thanks to continuous support it delivers reliable results. Reports generated though are very limited and teams tend to use external plugins/tools for more detailed reporting.
f) Available resources: JMeter has one of largest online community which shares helpful information with each other through different forums and software testing blogs. Because of this reason JMeter is considered a great option for beginners in performance and load testing.

HP LoadRunner:

LoadRunner is a commercial performance testing solution developed by HP. It has very advanced set of features which usually do not come built in with open-source or free tools. Some of the key points about LoadRunner are listed below.
a) Commercial tool: LoadRunner is a commercial product by HP, falling in category of most expensive performance testing tools. HP LoadRunner license cost varies depending on required virtual users, protocols and perpetual licenses etc. Despite its high cost, it is still a preferable choice of enterprise testing teams because of its advanced features and dedicated customer support.
b) Components: LoadRunner is not a single application but a complete suite of tools like VU Generator, Controller, Analyzer, Load generator, Load calculator and protocol advisor.
c) Platform compatibility: LoadRunner can operate from Windows operating system.
d) Supported applications: HP LoadRunner (performance center) provides support for widest range of applications. It can be used to test performance of databases, server side applications and native/browser based mobile applications.
e) Advanced reports: LoadRunner is best known for its very detailed reports which help a lot in analyzing the performance issues.
f) Available resources: HP provides dedicated support & knowledge base for LoadRunner to all registered customers. Other than that, one can also find plenty of articles & video tutorials online on HP LoadRunner.

Saturday, October 8, 2016

Oracle database load testing

In this blog, I’ll tell you how to load test the oracle database using loadrunner. There are different ways to achieve it and one simple way is writing SQL queries in vugen script.

In this blog I’m going to tell how to connect to database, how to execute query and how to disconnect. I will be using lr_db functions to achieve this. Loadrunner help is very useful with details about lr_db functions.

Connect to Oracle database:

        "ConnectionString=Provider=OraOLEDB.Oracle; dbq=10.xx.xx.xx:1540; Data Source=XXXX; Persist Security Info=True; User ID=username; Password=password",

SQL statement:
                "ConnectionName= OracleDB",
                "SQLStatement=SELECT * FROM \"TableName\" ",
                LAST );

Disconnect from database:

                 "ConnectionName= OracleDB", LAST );

Oracle Client need to be installed in load generator machine and TNS entry should be there for data source.
Use web services protocol for loadrunner vugen script.