July 2009 - Posts

• The SQL Server Cost Based Optimizer

  I have updated this at the URL below, http://www.qdpma.com/SQLServerCostBasedOptimizer.html later I will update this blog as well Read More... Posted Sunday, July 26, 2009 10:27 PM by jchang | 0 Comments Filed under: cost based optimizer

• Automating Query Exec, Index Usage and Execution Plans, Update 2

  I have made updates to my tool for automating SQL Server query exec stats, index usage, execution plan analysis. So I would like people to give it a try and send feedback. If there is an error, please report the file and line number (the top level is Read More... Posted Monday, July 13, 2009 8:18 PM by jchang | 9 Comments Filed under: execution plans, Performance, tools

• Why have we not seen TPC-C and TPC-E benchmarks using SSD storage?

  Dell recently published a TPC-H report for the PowerEdge T610, 2 x Xeon 5570, with 4 FusionIO 80GB SSD storage devices at 100GB scale factor. So why have we not seen TPC-C or TPC-E OLTP benchmark results published? Now it is much more feasible to run Read More... Posted Wednesday, July 01, 2009 1:48 PM by jchang | 8 Comments Filed under: Hardware, Performance, SSD