Thursday, October 24, 2013

11 HammerDB : Load Testing

HammerDB is well known load testing application. Formally known as Hammerora.

You can download the latest version from SourceForge . http://hammerora.sourceforge.net/ 

image

Installation

Very straight forward.  It does not have the Chinese language , Maybe I should create one Smile 

image

image

image

image

We need to pay attention on the connection property. Generally, I use HostName,PortNumber to connect to the SQL Server.  However, the HammerDB is using Name Pipe to connect to the SQL Server. If we simply use Host Name ( in the example below , the host name is SGC3), we would get the name pipe error: 

{[Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [2]. }
Therefore, we have to use HOSTNAME\INSTNACE_NAME

image

Create Virtual User

image

image

image

Start Transaction counter

image

Run Virtual Users

image

From HammerDB console, you can see 3 virtual users has execute the query .

image

Switch to the transaction counter, you can see the transaction statistic .

 

image

From SQL Server Activity monitor, you can see there are three spid coming from Tk 8.6 which is the HammerDB processes.

image

Stop the Virtual User

image

You can also find other Load testing tools from my previous post.

11 comments:

  1. Excellent article!!! LoadRunner is popular automation testing tool used for validating a software application/system under load. It delivers most precise information about the performance, functionality and behavior of the software product. Best Loadrunner training institute in Chennai | Loadrunner training

    ReplyDelete
  2. I am following your blog from the beginning, it was so distinct & I had a chance to collect conglomeration of information that helps me a lot to improvise myself. I hope this will help many readers who are in need of this vital piece of information. Thanks for sharing & keep your blog updated.
    Regards,
    CCNA Training in Chennai | CCNA Training institute in Chennai | CCNA Training

    ReplyDelete
  3. Really cool post, highly informative and professionally written and I am glad to be a visitor of this perfect blog, thank you for this rare info! , Regards, servicenow training in hyderabad

    ReplyDelete
  4. Great Information,it has lot for stuff which is informative.I will share the post with my friends.
    Case Study Helper

    ReplyDelete
  5. Professional Expert level Android Training in chennai, Android App Development
    Android Training | Android App Development | Training in chennai

    ReplyDelete
  6. Professional Expert level Android Training in chennai, Android App Development
    Android Training | Android App Development | Training in chennai

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates