Tuesday, November 20, 2012

140 SQL Server Load testing: Hammerora,SQLQueryStress and others

Time to time I have the need to simulate the workload for different reasons, such as exercise the SQL Server P/T, knowing how much load the SQL Server can take or even want to replicate some condition cause my sql server crash. I like to use this post document some of the method I have found.


Hammerora is the open source database load testing application. It can run the TPC-C and TPC-H load against MSSQL, Oracle and other DBMS.  The latest version when this post is written is 2.9. However, you need to go to the sourceforge page and browser the download to find the 2.9.

Setup the Benchmark type

Select the option –> Benchmark and choice the DBMS and the Benchmark options.

In this case, I selected MSSQL Server and TPC-C.


Configure Server connection and warehouse

options –> TPC-C Schema –> Build and Driver


This screen is for setting up the database connection and base configuration.

Warehouses value is to decide the size of the testing database. Warehouse 1 is around 130MB. In this case, I use 5 which would build the database name tpcc with 650 MB of dummy data.

There are 2 type of TPC drivers script we can choice.

Standard driver script: Hammerora would run the continuously testing until you stop it.

Timed Test Driver Script: You can set up how long you want to run the test load.


There is also the option to configure how many virtual users would used.


After all configure is done. click cube button to create the schema.


This would take sometime to completed….


Test the virtual user script



Test complete


Create the 10 Virtual Users testing


Run Virtual user loads



Use activity monitor to monitor the server status




In theory, you can write any application to run the customize query to simulate the load. Perl is good as any. My college write the shell script and connect to MSSQL from unix and run the query. In the Shell script he put the for loop and spawn numerous of background processes which would do the job.


Since I am primary focus on testing the MSSQL load. It make sense to explore the powershell option. It turns out it is not easy as using Shell. As far as my research goes,  there are 2 ways to simulate the threading in powershell. Background jobs and runspace.

You can find the runspace example from here.


Document: http://www.datamanipulation.net/SQLQueryStress/documentation/documentation.asp

In this test, I just execute the simple sp: uspGetEmployeeManager  from AdventureWorks.

Set up the Iterations to 50 with 30 threads.


Click the database for configure the connection.


Parameter Matching

The good thing for this tool is parameter matching. You can substitute with store procedure’s parameter from select statement. In this example, I substitute employee ID from  Employee table.


Click the Go to run the test



It seems to be easy to use from the screenshot, however, I can not make it connect to my SQL Server 2008R2  instance. I have tried both default instance and name instance but can not get it work.



Other tools:

Here are some other tools I found in the internet but not yet test.


  1. Thanks for sharing such informative article on Loadrunner Automation testing tool. This load testing tool will provide most precise information about the quality of software. Loadrunner training

    1. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a Java developer learn from Java Training in Chennai. or learn thru Java Online Training in India . Nowadays Java has tons of job opportunities on various vertical industry.

      or Javascript Training in Chennai. Nowadays JavaScript has tons of job opportunities on various vertical industry.

  2. I am reading ur post from the beginning, it was so interesting to read & i feel thanks to you for posting such a good blog, keep updates regularly.Best Hadoop Training Institute In Chennai

  3. 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.
    CCNA Training in Chennai | CCNA Training institute in Chennai | CCNA Training

  4. Fantastic write-up together with excellent website, I enjoy these kinds of challenging content articles keep this specific somebody affordable seo packages

  5. The future of software testing is on positive note. It offers huge career prospects for talented professionals to be skilled software testers. software testing course in Chennai | Software Testing Training in Chennai | Software testing course in Chennai

  6. • best and useful sites and I like the sites..

    sas training in chennai

  7. Greens Technology's. the leading software Training & placement centre Chennai & (Adyar)
    hadoop training in chennai

  8. Greens Technology's. the leading software Training & placement centre Chennai & (Adyar)
    oracle-apps-hrms training in chennai

  9. Wonderful post.This is really one of the most beneficial blogs I’ve ever browsed on this subject. I am very glad to read such a great blog
    Best software Testing Training institute in Chennai | Software Testing courses in Chennai | Testing Training Chennai

  10. your information sybase very nice .it's more informative and gather new ideas implemnted thanks for sharing this blog sybase training In Chennai if want to get details now Greens Technologies Training In Chennai

  11. Wonderful blog.. Thanks for sharing informative blog.. its very useful to me..

    iOS Training in Chennai


  12. Being new to the blogging world I feel like there is still so much to learn. Your tips helped to clarify a few things for me as well as giving..
    Android App Development Company

  13. great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
    web design Company
    web development Company
    web design Company in chennai
    web development Company in chennai
    web design Company in India
    web development Company in India

  14. Being new to the blogging world I feel like there is still so much to learn. Your tips helped to clarify a few things for me as well

    iOS App Development Company
    iOS App Development Company

  15. These ways are very simple and very much useful, as a beginner level these helped me a lot thanks fore sharing these kinds of useful and knowledgeable information.
    Fitness SMS
    Salon SMS
    Investor Relation SMS

  16. it is really amazing...thanks for sharing....provide more useful information...
    Mobile app development company

  17. This article is very much helpful and i hope this will be an useful information for the needed one. Keep on updating these kinds of informative things...
    Texting API
    Text message marketing
    Digital Mobile Marketing
    Sms API
    Sms marketing

  18. Your very own commitment to getting the message throughout came to be rather powerful and have consistently enabled employees just like me to arrive at their desired goals."Devops Training in Chennai"

  19. I have to voice my passion for your kindness giving support to those
    people that should have guidance on this important matter.

    Selenium Training in Chennai

  20. Hats off to your presence of mind..I really enjoyed reading your blog. I really appreciate your information which you shared

    Java Training in Bangalore|

  21. It’s great to come across a blog every once in a while that isn’t the same out of date rehashed material. Fantastic read.
    I’ve bookmarked your site, and I’m adding your RSS feeds to my Google account.
    dot net training in bangalore

  22. Those guidelines additionally worked to become a good way to recognize that other people online have the identical fervor like mine to grasp great deal more around this condition.

    Hadoop training in bangalore

  23. I am commenting to let you know what a terrific experience I enjoyed reading through your web page. I noticed a wide variety of pieces, with the inclusion of what it is like to have an awesome helping style to have the rest without hassle grasp some grueling matters.
    Hadoop Training in Bangalore

  24. Hey, would you mind if I share your blog with my twitter group? There’s a lot of folks that I think would enjoy your content. Please let me know. Thank you. AWS Training in Bangalore

  25. It’s great to come across a blog every once in a while that isn’t the same out of date rehashed material. Fantastic read."Oracle Training in Bangalore"

  26. I simply wanted to thank you so much again. I am not sure the things that I might have gone through without the type of hints revealed by you regarding that situation.
    Besant technologies Marathahalli

  27. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    rprogramming training in bangalore

  28. Nice blog on Selenium Testing!!! I agree with your points, Testing will help whole organization to handle the projects in efficient manner.

    Software testing training in Velachery | Testing training in chennai

  29. Hi! Just commenting on how great your website looks! may I ask if you are using wordpress? By the way, if you ever need business incorporation services, I know the best company secretarial services assistant! accounting company now!

  30. This comment has been removed by the author.

  31. Hey there, You have done a fantastic job. I’ll definitely digg it and personally suggest to my friends. I am confident they will be benefited from this web site.

    PSD to Wordpress
    wordpress website development

  32. It's interesting that many of the bloggers to helped clarify a few things for me as well as giving. Most of ideas can be nice content. The people to give them a good shake to get your point and across the command.
    oracle training in chennai|| hadoop training in chennai

  33. It a very intensive course but it has provided me a very rewarding experience, I find it very useful and it helped boosting my self-confidence.

    Graphic designing Training Institute in Chennai | CorelDraw Training Institute in Chennai | Photoshop Training Institute in Chennai

  34. Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating.
    oracle training in chennai|| hadoop training in chennai

  35. Excellent post. I have read your blog it's very interesting and informative. Keep sharing.
    mobile website builder

  36. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
    hadoop training in chennai || selenium training in chennai

  37. Appreciation for really being thoughtful and also for deciding on
    certain marvelous guides most people really want to be aware of.

    white label website builder

  38. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one

    software testing training online


  39. Grate blog to read its very nice explanation about Internet Of Things
    Austere Technologies |Internet Of Things

  40. Very good informative article. Thanks for sharing such nice article, keep on up dating such good articles.

    Best Software Company in USA | Austere Technology Solutions

  41. Very good informative article. Thanks for sharing such nice article, keep on up dating such good articles.

    Best Cloud Services | Austere Technology Solutions

  42. Such a informative post.Thanks for sharing your knowledge with us.keep it up for updating post..
    iot training in chennai | top 10 embedded training institutes in chennai .

  43. IOT Training in Bangalore - Live Online & Classroom
    IOT Training course observes iot as the platform for networking of different devices on the internet and their inter related communication. Reading data through the sensors and processing it with applications sitting in the cloud and thereafter passing the processed data to generate different kind of output is the motive of the complete curricula. Students are made to understand the type of input devices and communications among the devices in a wireless media.

  44. AWS Training in Bangalore - Live Online & Classroom
    myTectra Amazon Web Services (AWS) certification training helps you to gain real time hands on experience on AWS. myTectra offers AWS training in Bangalore using classroom and AWS Online Training globally. AWS Training at myTectra delivered by the experienced professional who has atleast 4 years of relavent AWS experince and overall 8-15 years of IT experience. myTectra Offers AWS Training since 2013 and retained the positions of Top AWS Training Company in Bangalore and India.

  45. mytectra placement Portal is a Web based portal brings Potentials Employers and myTectra Candidates on a common platform for placement assistance.

  46. Wow...Excellent informative blog, really helpful. Thank you.

    Best CMA Training in hyd | ISFS

  47. Best R Programming Training in Bangalore offered by myTectra. India's No.1 R Programming Training Institute. Classroom, Online and Corporate training in R Programming
    r programming training

  48. Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us. Do check Six Sigma Training in Bangalore | Six Sigma Training in Dubai & Get trained by an expert who will enrich you with the latest trends.

  49. Your article gives lots of information to me. Thanks for sharing.
    acca course in hyderabad | ISFS

  50. Amazing article. Your blog helped me to improve myself in many ways thanks for sharing this kind of wonderful informative blogs in live. I have bookmarked more article from this website. Such a nice blog you are providing ! Kindly Visit Us @ Best Travels in Madurai | Tours and Travels in Madurai | Madurai Travels

  51. I have read your blog its very attractive and impressive. I like it your blog.
    Best AWS training in marathahalli bangalore

  52. Appreciation for really being thoughtful and also for deciding on certain marvelous guides most people really want to be aware of.
    Devops Training in Chennai | Devops Training Institute in Chennai

  53. The article is very interesting and very understood to be read, may be useful for the people. I wanted to thank you for this great read!! I definitely enjoyed every little bit of it. I have to bookmarked to check out new stuff on your post. Thanks for sharing the information keep updating, looking forward for more posts..
    Kindly visit us @
    Madurai Travels | Travels in Madurai
    Best Travels in Madurai
    Cabs in Madurai | Madurai Cabs
    Tours and Travels in Madurai

  54. Your info is really amazing with impressive content..Excellent blog with informative concept. Really I feel happy to see this useful blog, Thanks for sharing such a nice blog..
    If you are looking for any Data science Related information please visit our website Data Science Course In Bangalore page!

  55. Thank you for excellent article.You made an article that is interesting.
    AWS Solutions Architect courses in Bangalore with certifications.

  56. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. Machine Learning Final Year Projects In case you will succeed, you have to begin building machine learning projects in the near future.

    Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.

    Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.

  57. I am glad that I saw this post. It is informative blog for us and we need this type of blog thanks for share this blog, Keep posting such instructional blogs and I am looking forward for your future posts.
    Cyber Security Projects for Final Year

    JavaScript Training in Chennai

    Project Centers in Chennai

    JavaScript Training in Chennai

  58. Hello Admin!

    Thanks for the post. It was very interesting and meaningful. I really appreciate it! Keep updating stuffs like this. If you are looking for the Advertising Agency in Chennai | Printing in Chennai , Visit Inoventic Creative Agency Today..

  59. good training institute in pune

  60. Attend The Artificial Intelligence course From ExcelR. Practical Artificial Intelligence course Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Artificial Intelligence course.
    Artificial Intelligence Course

  61. The data that you provided in the blog is informative and effective.I am happy to visit and read useful articles here. I hope you continue to do the sharing through the post to the reader. Read more about

    selenium training in chennai

    selenium training in chennai

    selenium online training in chennai

    selenium training in bangalore

    selenium training in hyderabad

    selenium training in coimbatore

    selenium online training

  62. I must thank you for the efforts you have put in penning this site. I am hoping to check out the same high-grade content by you later on as well. Keep up the good workThis blog is the general information for the feature. You got a good work for these blog.We have a developing our creative content of this mind.Thank you for this blog. This for very interesting and useful.Java training in Chennai

    Java Online training in Chennai

    Java Course in Chennai

    Best JAVA Training Institutes in Chennai

    Java training in Bangalore

    Java training in Hyderabad

    Java Training in Coimbatore

    Java Training

    Java Online Training


  63. I recently came across your article and have been reading along. I want to express my admiration of your writing skill and ability to make readers read from the beginning to the end. I would like to read newer posts and to share my thoughts with you.Your post is just outstanding! thanks for such a post,its really going great and great work.You have provided great knowledge

    Azure Training in Chennai

    Azure Training in Bangalore

    Azure Training in Hyderabad

    Azure Training in Pune

    Azure Training | microsoft azure certification | Azure Online Training Course

    Azure Online Training

  64. I need to to thank you for your time due to this fantastic read!! I definitely enjoyed every bit of it and I have you bookmarked to see new information on your blog.
    DevOps Training in Chennai

    DevOps Online Training in Chennai

    DevOps Training in Bangalore

    DevOps Training in Hyderabad

    DevOps Training in Coimbatore

    DevOps Training

    DevOps Online Training

  65. Great site and a great topic as well I really get amazed to read this.This is incredible,I feel really happy to have seen your webpage.I gained many unknown information, the way you have clearly explained is really fantastic.keep posting such useful information.
    Full Stack Training in Chennai | Certification | Online Training Course
    Full Stack Training in Bangalore | Certification | Online Training Course

    Full Stack Training in Hyderabad | Certification | Online Training Course
    Full Stack Developer Training in Chennai | Mean Stack Developer Training in Chennai
    Full Stack Training

    Full Stack Online Training

  66. I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
    Data Science Training In Chennai

    Data Science Online Training In Chennai

    Data Science Training In Bangalore

    Data Science Training In Hyderabad

    Data Science Training In Coimbatore

    Data Science Training

    Data Science Online Training

  67. Hey!

    DigiPeek is the best SEO & Link Building Service Provider In The World. I have 7+ Years Experience To Build SEO, Backlinks & Improve Website Ranking.

    If you need Profile Backlinks, Forum Backlinks, Dofollow Backlinks, Manual Backlinks, Trusted SEO Backlinks, Increase Domain Rating Then You Will Contact Me.

    I am glad to help You!

    Let's TRY!

  68. I feel really happy to have seen your webpage.I am feeling grateful to read this.you gave a nice information for us.please updating more stuff content...keep up!!

    Android Training in Chennai

    Android Online Training in Chennai

    Android Training in Bangalore

    Android Training in Hyderabad

    Android Training in Coimbatore

    Android Training

    Android Online Training

  69. Thanks for one marvelous posting! I enjoyed reading it; you are a great author. I will make sure to bookmark your blog and may come back someday. I want to encourage that you continue your great posts.
    acte chennai

    acte complaints

    acte reviews

    acte trainer complaints

    acte trainer reviews

    acte velachery reviews complaints

    acte tambaram reviews complaints

    acte anna nagar reviews complaints

    acte porur reviews complaints

    acte omr reviews complaints

  70. very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.

    IELTS Coaching in chennai

    German Classes in Chennai

    GRE Coaching Classes in Chennai

    TOEFL Coaching in Chennai

    spoken english classes in chennai | Communication training

  71. Thanks for sharing such informative article on Loadrunner Automation testing tool. This load testing tool will provide most precise information about the quality of software.

    AWS Course in Bangalore

    AWS Course in Hyderabad

    AWS Course in Coimbatore

    AWS Course

    AWS Certification Course

    AWS Certification Training

    AWS Online Training

    AWS Training

  72. Wow! Such an amazing and helpful post this is. I really really love it. I hope that you continue to do your work like this in the future also.

    Big Data Training Institute in Pune
    Hadoop Training in Pune

  73. Thank you so much for exploring the best and right information about how useful is Informatica's set of tools and how one grasp the best out of it can.

    Informatica Read Rest API

  74. Nice Blog...looking amazing...thank you so much for sharing such a wonderful blog...keep sharing
    Quikads is the best classified ads platform in Bangladesh. Advertise your products here freely.

  75. The UTM has two crossheads, one is changed in accordance with oblige the length of the example and the other one is using pressurized water or electromagnetically headed to create the tensile strain on the example. tensile strength testing machine

  76. I amazed with the research you made to make this actual submit incredible.
    Great activity!

    Have a look at my homepage;출장안마



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