Quantitative Database Performance and Modeling
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
Articles
Performance Tuning
The SQL Server Cost-Based Optimizer (Execution Plan Cost Model)
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
The SQL Server Cost-Based Optimizer (Execution Plan Cost Model)
SQL Performance Tools
Downloads
SQL Exec Stats Build 2009-06-28
Trace Analysis Build 2009-01-11
Links