Characterization of TPC-H queries on AMD Athlon/sup TM/ microprocessors

Studies on TPC-H based workloads have been few. The ever increasing, Internet based transactions necessitate better design of Servers running database applications. Business managers run DSS (Decision Support System) applications to analyze various business scenarios. This paper characterizes a small subset of a DSS workload obtained from the TPC-H benchmark from TPC (Transaction Processing Council). This characterization is done at the system level using performance-monitoring counters. Through this process, we attempt to analyze the queries behavior on the Athlon, the effect of the Athlon's micro-architecture on executing the queries, and compare and contrast two different L2 cache implementations.