I've been tasked to stress test our MSSQL Server and MySQL Server. I would like to know if there are any tools or scripts which I could use on our current systems and the new system to compare performance?

I would like to measure read / write to disk and processor performance. Anything else that may be useful would be great as well.


  • 6
    For SQL Server, I'm frequently mentioning the RML tools which are discussed in dba.stackexchange.com/questions/5809/…. Oct 20, 2011 at 17:32
  • Thanks for the post. Great set of tools for MSSQL. I'll have to give it a shot and see what I can come up with. This actually helps in our environment as I can re-create user activity with our database. That said, I also found SQLIOSim from Microsoft. It doesn't quite test the DB but it does test the IO of the system which the DB lives on. support.microsoft.com/kb/231619 Oct 20, 2011 at 18:23
  • 2
    Careful with SQLIOSIM, it's intended to test IO stability rather than capability blogs.msdn.com/b/psssql/archive/2008/04/05/…. SQLIO is the tool you want instead. Oct 20, 2011 at 18:34
  • Please also look at our DTM DB Stress tool (www.sqledit.com/stress). It was designed for exact requested purpose. Jan 13, 2013 at 7:02
  • JMeter comes to mind, should work for both (you could even run the same/identical if you design them properly)
    – user1822
    Jan 13, 2013 at 12:30

3 Answers 3


Quest offers a free version of their Benchmark Factory that works for Oracle, SQL Server, and MySQL:


I recorded a video on getting started with it back when I worked for Quest:


You can call your own stored procs, replay traces, run TPC benchmark scripts, and more. It's not exactly easy to use, though - thus the video.


For MySQL, there's the official benchmark suite. Alternatively a tool like sysbench. I'm currently in the process of testing out sysbench, but I've been having some trouble!


The defacto standard for comparing one database solution to another is the TPC-C benchmark. The latest definition of this benchmark can be downloaded from http://www.tpc.org/tpcc/default.asp along with existing benchmark result sets.

While it is unlikely you will run the full TPC-C at your location, the test definition should provide the foundation for developing a set of internal benchmarks designed to identify performance differences on a reference set of hardware with respect to your organization's specific requirements for transactional throughput.

Make sure you download the cost of ownership documentation as well, for this can provide a standardized method for evaluating the two solutions.

Not the answer you're looking for? Browse other questions tagged or ask your own question.