March 12, 2014 at 4:14 pm
Im looking to setup a test environment at home and was curious if anyone has any ideas as to how i could produce transactions ? Id like to see the fruits of clustering, failover, availability etc. and would like to see constant data ?
Basically i want to emulate a production environment.
Thanks for any ideas
March 12, 2014 at 4:53 pm
If you're on SQL Server 2012, then the answer is the Distributed Replay tool. With that you can simulate load on the system. You'll have to build the load yourself, but you'll only have to do that once and then you can rerun it all you want. I also use a PowerShell script to call stored procedures from AdventureWorks in a loop. That's pretty easy to set up. It doesn't simulate a good load, but it simulates a load of some kind.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply