12

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.

Thanks!

Community
  • 1
stanleykylee
  • 474
  • 1
  • 6
  • 21

3 Answers3

11

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

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

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

http://www.toadworld.com/Videos/tabid/831/TID/559/cid/161/Default.aspx

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.

Brent Ozar
  • 43,325
  • 51
  • 233
  • 390
4

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!

Community
  • 1
Derek Downey
  • 23,568
  • 11
  • 79
  • 104
3

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.

James Pulley
  • 353
  • 2
  • 4