locked
Test Performance RRS feed

  • Question

  • We have a Web Service that uses Sql Server 2012. We would like to have performance reach 100,000 transactions per second. 

    Does anyone know the best products or methods to perform such tests? Essentially based on certain hardware requirements what is the total transactions and time per transaction that the code is able to meet....


    Thanks, Aaron

    Friday, March 22, 2013 2:29 PM

Answers

  • Hello Aaron!

    You have some ways to do that!

    You can "replay" the transactions collected in a period of time using the SQL PROFILER:

    http://msdn.microsoft.com/en-us/library/ms189604.aspx

    You can use the "replay" of the rml utilities:

    http://support.microsoft.com/kb/944837

    If you want to test just a kind of query you can use the query stress:

    http://www.mssqltips.com/sqlservertip/2730/sql-query-stress-tool/

    Or you can use tools around the market like the one in the link below:

    http://www.quest.com/benchmark-factory/

    Regards,


    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br

    Friday, March 22, 2013 3:19 PM