Chapter 10. How to Run an Analytic Workload

Table of Contents


1. SUT Database Server Configuration
2. Installation and Configuration
2.1. Oracle
2.2. SQL Server
2.3. Db2
2.4. PostgreSQL
2.5. MySQL / MariaDB
3. Configuring Schema Build Options
3.1. Oracle Schema Build Options
3.2. SQL Server Schema Build Options
3.3. Db2 Schema Build Options
3.4. MySQL Schema Build Options
3.5. PostgreSQL Schema Build Options
4. Creating the Schema
4.1. Verifying and Backing-Up the Oracle Schema
4.2. Verifying and Backing Up the SQL Server Schema
4.3. Verifying and Backing up the Db2 Schema
4.4. Verifying and Backing up the MySQL Schema
4.5. Verifying and Backing up the PostgreSQL Schema
5. Configuring Driver Script Options
6. Loading the Driver Script
7. Configure Virtual Users
8. Run a Single Virtual User Test
8.1. Changing the Query Order
9. Run a Power Test
10. Run a Throughput Test
10.1. SQL Server Snapshot Isolation
11. Calculate the QphH

The basis of Analytic or Decision Support Systems is the ability to process complex ad-hoc queries on large volumes of data. Processing this amount of data within a single process or thread on traditional row-oriented database is time consuming. Consequently it is beneficial Parallel Query to break down such queries into multiple sub tasks to complex the query more quickly. Additional features such as compression and partitioning are also used with Parallel Query to improve performance. As a consequence when planning analytic workloads for optimal performance you should consider the database features for in-memory and parallel execution configuration. In similarity to the HammerDB OLTP workload, HammerDB implements a fair usage of a TPC workload however the results should not be compared to official published TPC-H results in any way.