0 - 2 of 2 tags for workload simulation

TdBench is a query driver optimized for data warehouse benchmarks and works with any database that has a JDBC driver. It runs on Windows or Linux. It has been tested and used in benchmarks with Teradata, Postgresql, MySQL, Redshift, Netezza, IBM SailFish, Greenplum, Azure ASDW, SQL Server, and Snowflake. TdBench accumulates test results in an internal H2 database for analysis and can link to host database query logging for complete analysis of test results.

Instructional Videos:


Video Title



TdBench 8.0 Overview

This video provides an overview of TdBench with some examples of how it is used to execute tests with SQL and OS commands, query from its local database, consolidating results from multiple vendors and integration with host DBMS reporting.


TdBench 8.0 Installation on Linux

This video provides instructions for downloading and configuring TdBench to work with your DBMS under Linux.


TdBench 8.0 Installation on Windows

This video provides instructions for downloading and configuring TdBench to work with your DBMS under Windows.


TdBench 8.0 Command Language

This video describes how TdBench processes statements when setting up and running a test. It also describes a subset of the commands you can use to build, debug, and run your tests.


TdBench 8.0 Reporting From DBMS Query Logging

TdBench can assist in analysis of host DBMS query logging and resource usage data by providing an interface to maintain test metadata on the host DBMS. This video shows how to set it up and demonstrates its usage with Teradata.


TdBench 8.0 Demo With TPC-H

This video provides a demonstration of building serial and workload tests using the Transaction Processing Council "H" tables and queries  (TPC-H)


TdBench 8.0 How To Design A Good Benchmark

This video describes how to structure a benchmark project, starting with creating the vision, defining critical success factors, defining a realistic workload that is sufficient to make a decision without "boiling the ocean", setup, testing, and execution of the benchmark, leveraging TdBench.


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.