Best way to run high number of transactions concurrently

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Best way to run high number of transactions...

Best way to run high number of transactions concurrently

Rate Topic

Display Mode

Topic Options

Author

Message

Maddave

Posted Thursday, September 27, 2012 5:12 AM

Valued Member

Group: General Forum Members
Last Login: Today @ 6:31 AM
Points: 63, Visits: 191

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

brendan woulfe

Posted Thursday, September 27, 2012 7:02 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:54 AM
Points: 193, Visits: 926

I would take a look at SQL query stress by Adam Machanic.

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

Post #1365215

Jason-299789

Posted Thursday, September 27, 2012 7:04 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 10:57 AM
Points: 838, Visits: 2,200

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

Maddave

Posted Thursday, September 27, 2012 7:19 AM

Valued Member

Group: General Forum Members
Last Login: Today @ 6:31 AM
Points: 63, Visits: 191

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

Grant Fritchey

Posted Thursday, September 27, 2012 8:43 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:49 AM
Points: 13,436, Visits: 25,281

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 »

Permissions