SQL server 2008 Stress/Load Generator Script

Posted on 2011-10-06
Last Modified: 2012-05-12
Hi All,
I need to test a database transaction rate as well as performance of a SQL server 2008 before handing it over to a 3rd party who will be installing their application against my SQL install.  

I need to make sure that my installation does stand their workload and scrutiny. The workload is not defined but they need something which will support thousands of transactions a minute.

Does anyone here have a T-SQL script which can
-      Create some sample tables with indexes, clustered indexes , triggers etc to simulate real schema
-      Insert millions of records in them ( To test insert x’action rate)
-      Then update those records ( To test update x’action response time )
-      Finally delete millions of records   ( To test delete x’action response time )

The application will first create raw seed data and then update over time. I used SQLIO to bencmark SAN speed but now need SQL x'action speed details.

Many Thanks
Question by:crazywolf2010
    1 Comment
    LVL 39

    Accepted Solution

    You realize that these are very much dependent on the Hardware and Software environment where SQL is running and data is hosted right?

    In the past we used "Vantage" in the past with very much success to proof our clients the app can run soo many concurrent users and soo many transactions in a given hard/soft environment

    More recently I used SQLStress - please see link below:

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

         When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now