TPC-C workload


TPC-C实现了一个计算系统,模拟公司内的订单。

该公司出售100,000件商品并将其stock(库存)保留在warehouses中。

每个warehouse有10个销售区域,每个销售区域服务于3000个客户。

客户会调用公司订单,每个订单包含了一定数量的商品。

订单通常由本地warehouse来满足,如果某些特定的时间,一些商品在本地仓库没有,那么将从其他仓库提供。


仓库和销售区域设置的越多,说明公司规模越大,系统负载就越高,同时也就需要更高的算力。


TPC-C Schema



这里说到的warehouse和数据仓库没有关系,表示的含义为物理意义上的仓库,对应数据库中的库存表。

TPC-C定义的是事务交易型系统,而非决策支持(DSS)。



TPC-C  build options


Number of Warehouses

The Number of Warehouses is selected by a listbox. You should set this value to number of warehouses you have chosen for your test.


设置仓库的数量,数量越多,系统越复杂。工作负载越高。

Virtual Users to Build Schema

The Virtual Users to Build Schema is the number of Virtual Users to be created on the Load Generation Server that will complete your multi-threaded schema build. You should set this value to either the number of warehouses you are going to create (You cannot set the number of virtual users lower than the number of warehouses value) or the number of cores/Hyper-Threads on your Load Generation Server. If you have a significantly larger core/Hyper-Thread count on your Database Server then also installing HammerDB locally on this server as well to run the schema build can take advantage of the higher core count to run the build more quickly.


将此值设置为等同于上面warehouses的数量(不能小于);

或者设置为cpu核数或线程数;



TPM : transactions per minute

NOPM : new orders per minute




  • No labels