September 27, 2012 at 5:12 am
Hi,
I have been asked to see if our new database system is up to handling a high load and need to run a transaction which includes a number of inserts and selects multiple times, to see the speeds that can be achieved. Ideally we are looking to want about 300 transactions a second and need to see how this can be tuned and improved.
I am interested in knowing what the best way to simulate multiple transactions to the database and what tool or way is possible to do this?
Thanks.
September 27, 2012 at 7:02 am
I would take a look at SQL query stress by Adam Machanic.
September 27, 2012 at 7:04 am
Red gate do an addin for SSMS http://www.red-gate.com/products/sql-development/sql-test/?utm_source=google&utm_medium=cpc&utm_campaign=sqltest&gclid=CKb0gOzo1bICFQMNfAod1kYAkw
_________________________________________________________________________
SSC Guide to Posting and Best Practices
September 27, 2012 at 7:19 am
brendan woulfe (9/27/2012)
I would take a look at SQL query stress by Adam Machanic.
That's brilliant. Just what I needed for these initial tests. I was just starting to write my own program to do the exact same thing!
Thanks.
September 27, 2012 at 8:43 am
You can use the Profiler GUI to playback a trace against a server. But, it's single threaded, so you're not going to be able to scale it up much. SQL Server 2012 includes a new tool, Distributed Replay. You can run that against a 2008 database. It allows you add lots and lots more machines to run a trace playback. You can really stress the system to the max that way.
"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 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply