October 18, 2011 at 2:58 am
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
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
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
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
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