InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 01:41:02 GMT20http://www.sqlservercentral.com/Forums/Topic1365144-392-1.aspxYou 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.Thu, 27 Sep 2012 08:43:15 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1365144-392-1.aspx[quote][b]brendan woulfe (9/27/2012)[/b][hr]I would take a look at SQL query stress by Adam Machanic. [url]http://www.datamanipulation.net/sqlquerystress/[/url][/quote]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.Thu, 27 Sep 2012 07:19:32 GMTMaddavehttp://www.sqlservercentral.com/Forums/Topic1365144-392-1.aspxRed gate do an addin for SSMS [url]http://www.red-gate.com/products/sql-development/sql-test/?utm_source=google&utm_medium=cpc&utm_campaign=sqltest&gclid=CKb0gOzo1bICFQMNfAod1kYAkw[/url]Thu, 27 Sep 2012 07:04:29 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1365144-392-1.aspxI would take a look at SQL query stress by Adam Machanic. [url]http://www.datamanipulation.net/sqlquerystress/[/url]Thu, 27 Sep 2012 07:02:32 GMTbrendan woulfehttp://www.sqlservercentral.com/Forums/Topic1365144-392-1.aspxHi, 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.Thu, 27 Sep 2012 05:12:44 GMTMaddave