[Lbs-tech] [Announce] Database workload toolkit - DBT-1

[Craig T. <cr...@os...>]

OSDL has created a database workload that simulates an ecommerce book
store.  The back end of the database is SAP.  The tool is named DBT-1
and is derived from the TPC-W benchmark.  The code is Open Source and
can be found on sourceforge:

      http://sourceforge.net/projects/osdldbt/ 


We have posted initial performance statistics on the following web site:

      http://www.osdl.org/projects/dbt1prfrns/results

The table will eventually grow as more kernels are tested on different
systems. Currently we have performance characteristics for a 2-way
system, 1 GB memory, utilizing 10 disk spindles for its database.  The
other performance measurements are conducted on a 8-way system, 16 GB
memory, utilizing 12 disk spindles for its database.  These runs involve
the same number of users accessing the database.

In addition to capturing database transaction numbers, data is captured
for I/O, memory usage, and CPU utilization.  Currently, the performance
work is being conducted on 2.4 kernels.

However, STP is running a smaller version of this test on 2.5 kernels. 
The first results from this run is located at

    http://khack.osdlab.org/stp/3441/

It would be interesting to see how this database workload performed on
other types of systems.  Is there anyone willing to try this out?

-- 
Craig Thomas                         phone: 503-626-2455  ext. 33
Open Source Development Labs         email: cr...@os...