Joe Chang, SQL Server Consultant
jchang@qdpma.com, or jchang6@yahoo.com
Note: I am still working on this site, some links are broken or work in progress
SQL Server Benchmark Results November 2009
Solid State Drive versus Memory, TPC-H Nehalem
The SQL Server Cost-Based Optimizer (2009-07)
Execution Plan Cost Model (2008)
HP StorageWorks 2000 sa and fc G2 Modular Storage Arrays
Quantitative Performance Analysis
Database Architecture for minimum memory fit, most efficient and highly stable execution plans
Best Primary Key, Clustered Index and minimum set of nonclustered indexes
Writing SQL to force a specific execution plan
Predicting impact of execution plan changes with data distribution change over time
Direct-Attach and SAN Storage system configuration and performance verification
NUMA system specific and high call volume tuning techniques
Load Testing
I have not had time to do this properly, but for now here they are.
SQLExecStats documentation, in the process of being updated
SQL Exec Stats Build 2010-02-25
SQL Exec Stats Build 2010-02-10
Interim build, With interim documentation.
SQL Exec Stats Build 2010-02-03
Some new columns were added to the ShowPlans tab.
I will document the changes later.
The next version will move the StatementOptmLevel and StmtOptmEarlyAbortReason from the ShowPlan tab to the ExecStats tab.
This data structure change will mean that the new version will not work with data files form earlier versions.
SQL Clone Build 2010-03-04
This is an interim update for scripting Roles. A more thorough update is due, when I get a chance.
SQL Clone Build 2009-01-18
SQL System Build 2008-10-29
Trace Analysis Build 2009-01-11
Articles on SQL-Server-Performance