Q: Are there any free tools that I can use to generate a TPC-like workload on my SQL Server system?

A: Yes. HammerDB is a free open source database load testing tool that you can find at hammerora.sourceforge.net. HammerDB works with:

  • Oracle
  • SQL Server
  • TimesTen
  • PostgreSQL
  • Greenplum
  • Postgres Plus Advanced Server
  • MySQL
  • Redis

HammerDB can be run fully automated and it can produce a TPC-C like OLTP workload, as well as a TPC-H data warehousing workload.

Related: Data Warehouse Workloads and Use Cases