Home, Query Optimizer, Benchmarks, Server Systems, System Architecture, Processors, Storage, TPC-H Studies
Newer material, still work in process.
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.
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