TPC-W xSeries Benchmark–Lessons Learned

IBM ~ Performance Technical Report ™TPC-W xSeriesBenchmark–Lessons LearnedDiscussion of the impact configuration changes made between two™successive TPC-W publications using DB2 UDB EE and NUMA Technology forthe Database Server. Performance counter data reveals interestinginformation influencing the benchmark configuration.Mary Edie Meredith, Mark Wong, Basker Shanmugam, Russell Clapp503-578-4273, T/L 775-4273maryedie@us.ibm.comJanuary, 2002©2002 International Business Machines Corporation, all rights reservedTPC-W xSeries Benchmark - Lessons Learned Page 1IBM ~ Performance Technical ReportAbstract®In May of 2001, IBM published a leading Transaction Processing Performance Council™Benchmark W (TPC-W) results with DB2 Universal Database on the x430 system. A white™paper entitled “TPC-W Benchmark for IBM xSeries Servers - Leadership e-businessPerformance with IBM xSeries and DB2 Universal Database” documented the configuration andresults of that effort. This follow-on paper describes how the configuration evolved and whatissues motivated changes from an earlier publication on an E410 system to a publication on anx430. We present hardware performance counter data collected on the database server for eachpublication and describe what the data revealed about the TPC-W workload characteristics in aNUMA system environment.OverviewThe Transaction Processing Performance Council (TPC), is a standards body whose mission is toprovide transaction ...