Home, Query Optimizer, Benchmarks, Server Systems, System Architecture, Processors, Storage, TPC-H Studies

TPC-H Studies

Newer material, still work in process.
The Cost Model 2017-02 (in-progress)

Parallel Execution in SQL Server 2016 2017-01

Hyper-Threading 2013-03

TPC-H Studies at SF 10, 2010? (OK, I never finished this)

I have not had time to do this properly, but for now here they are. (This material is old and disorganized, I will rewrite later)
  TPC-H SF 100 Query Plans, non-parallel
  TPC-H SF 100 Query Plans, parallel
  SQL Server 2005 TPC-H SF 1 Query Plans, non-parallel
  Large Query Performance studies with TPC-H SF 10 (not compliant to reporting)
  TPC-H Studies at SF100 same as above, just raw data, no analysis

These two overlap, I will consolidate later:
  Date Correlation Optimization
  SQL Server TPC-H Tuning Parameters, relevant to data warehouse.

TPC-H SF 100 Execution Plans

Below are TPC-H SF 100 execution plans if any cares to examine them in detail. Do not click the link as the files are sqlplan files. I gave them an html extension for the website to allow downloads. Right click and select Save Target As.

TPC-H SF100 plans Non-parallel, no date correlation

TPC-H SF100 plans Non-parallel, with date correlation

TPC-H SF100 plans Parallel, no date correlation

TPC-H SF100 plans Parallel, with date correlation

TPC-H SF100 plans Query 3 non-parallel

TPC-H SF100 plans Query 4 non-parallel

TPC-H SF100 plans Query 5 non-parallel

TPC-H SF100 plans Query 5 parallel

TPC-H SF100 plans Query 7 non-parallel

TPC-H SF100 plans Query 8 non-parallel

TPC-H SF100 plans Query 10 non-parallel