Announcing:

TdBench 8.0 for any DBMS has been released! It works with any DBMS that supports JDBC.  The commands are very similar to earlier releases but there are many new features to improve simulation of data warehouse workloads. 

Click here for TdBench 8.0 for any DBMS

TdBench had originally been created to improve productivity in the setup and execution of competitive benchmarks. A 5.0 version that ran on MS/DOS was published in 2010 in conjuction with a Partners Presentation. 

The product has evolved considerably since then, first moving to Linux, and then adding new productivity features and tools.  With the 7.0 release, we added integration with PDCR data and this most recent release adds the ability to analyze data from a current and prior release of Teradata.

1. To allow customers where we have built "Upgrade Impact Benchmarks" to download updates to the query driver and its tools
2. To make the software available to other customers who want to build their own benchmarks to assess the impact of new software releases as Teradata moves to quarterly software updates.  

This latest version:

• Easily simulates complex workloads with simple commands
• Tracks tests, captures DBMS/TASM configurations and archives logs
• Provides analysis views and macros that select DBQL and Resusage data by RunID
• Setup builds analysis views  from
  • Resusage/DBQL in  DBC, or
  • DBC unioned to PDCR, or
  • current DBC release vs prior release DBC
• Open architecture in Linux allows running other applications including “brand x” query drivers to leverage tdbench reporting
• Support OS workers to support non-query activities such as data loading. Can be used to prepare benchmark in parallel.
• tdb.sh for command & control of active tests plus integration of tools like speedtest, backup_work, wrapup, and setting upTPC-DS and TPC-H benchmarks

There are 2 download versions for Linux and one for Windows:

1. Complete functionality query driver that installs on Linux, provides SETUP to create databases on Teradata, executes tests and provides analysis views
2. Same as #1, but also includes scripts data generator for TPC-DS and TPC-H built into the tools of tdb.sh

and

TdBench Excel template which

• allows selection of runs from the testtracking table,
• selection of macros/views beginning with RPT% in the benchmark database,
• allows additional constraints to be added for selects against views
• will create spreadsheets for the select views/macros and runids
• has buttons to update the Conditions and Notes columns in the testtracking table

Supplimental Materials: (See "Packages" above for software)

YouTube videos: