May 5, 2011 at 8:37 am
Hi,
I need a tool which generates load on a sample database. Since I have the schema, I need to give this as input to the tool, and specify the parameters of how many INSERT, DELETE, UPDATE, SELECT statement to generate. I need this tool to test real database with real life queries.
May 5, 2011 at 8:42 am
May 5, 2011 at 8:43 am
If you need a tool for benchmarking or measuring how well your db performs under stress, then SQLStress is a free tool that you can use.
For actual creation of load data you could use seed data generators, data generation in VS, or create custom scripts.
May 5, 2011 at 8:51 am
Actually I need to generate specific number (1000, 2000 etc) of sql queries (insert, delete, update) in a specific schema.
I don't need to test the performance of the database.
May 5, 2011 at 8:58 am
May 5, 2011 at 9:02 am
Any free tool?
May 5, 2011 at 9:07 am
Not that I know of.
Here's how you can do it manually :
http://www.sqlservercentral.com/articles/T-SQL/68467/
Check the section about "Populate the Test Table with Randomized Data"
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply