Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Best way to run high number of transactions concurrently Expand / Collapse
Author
Message
Posted Thursday, September 27, 2012 5:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 10, 2014 10:00 AM
Points: 138, Visits: 391
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.
Post #1365144
Posted Thursday, September 27, 2012 7:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 7:38 AM
Points: 208, Visits: 1,006
I would take a look at SQL query stress by Adam Machanic.

http://www.datamanipulation.net/sqlquerystress/
Post #1365215
Posted Thursday, September 27, 2012 7:04 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, April 17, 2014 7:37 AM
Points: 860, Visits: 2,323
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
Post #1365219
Posted Thursday, September 27, 2012 7:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 10, 2014 10:00 AM
Points: 138, Visits: 391
brendan woulfe (9/27/2012)
I would take a look at SQL query stress by Adam Machanic.

http://www.datamanipulation.net/sqlquerystress/


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.
Post #1365236
Posted Thursday, September 27, 2012 8:43 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 4:48 AM
Points: 14,802, Visits: 27,278
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1365316
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse