Post reply

Generic Stress Testing for SQL Server

  • October 18, 2011 at 2:58 am

    #246666

    I hope someone can help. I was wondering if anyone knows of an application that can generate a generic stress test.

    We are embarking on a new project and although we have a full end to end stress test process for our current application the new project requires us to evaluate some servers to see which ones give us the best ROI.

    The idea is to have the app generate a DB and possibly some stored procedures that it runs so we can capture the maximum batch requests per second, CPU usgae, Avergage Disk Queue Length etc.

    Our current databases we use for stress testing are huge and we don't want to copy them from our primary data centre to the new data centre that will host the new project. So the data for this particular testing is irrelevant as we are just measuring server performance between different spec servers.

    Currently what I have came up with was creating a db and populating with data using redgate's SQL Data Generator, but this still means I have to create procs etc and a batch process to call the procs which is pretty limited.

    MCITP SQL 2005, MCSA SQL 2012

  • October 18, 2011 at 5:24 am

    #1395817

    i have always used SQL Server IO Simulator. Its free from Microsoft.

    http://support.microsoft.com/kb/231619

    If you need to test your app code as it pertains to the database, you need to spend some money. HP LoadRunner is the best choice.

    http://www8.hp.com/us/en/software/software-product.html?compURI=tcm:245-935779

  • October 18, 2011 at 8:02 am

    #1395971

    Take a look at SQLStress. That can do quite a bit of stuff.

    SQLIOSim from Microsoft is also good as Geoff mentioned.

    -Roy

  • October 18, 2011 at 8:35 am

    #1396016

    Here's a good link to help you understand the output from SQL IO Sim;

    http://sqlblog.com/blogs/kevin_kline/archive/2007/06/28/understanding-sqliosim-output.aspx

    Cheers

    Vultar

  • October 18, 2011 at 9:16 am

    #1396067

    Thanks All this gives me a good starting point, I'll need to look into this app further as at a glance it looks like it mainly focuses on the Disk Subsystem.

    We do currently use Loadrunner quite extensivly but all the scripts and databases we have for this are currently in one country and the test enviornment we have for the servers is in another and they don't have a fast link between them to copy everything over so other than sending someone on a plan with the data on some external storage we need to build everything at the test site.

    MCITP SQL 2005, MCSA SQL 2012

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply