Over the last few months I’ve been blogging occasionally about some pretty deep performance tuning topics, namely latches and spinlocks (see my blog categories Wait Stats, Latches, and Spinlocks).

Ewan Fairweather and Mike Ruthruff of the SQLCAT team have written some really excellent whitepapers on interpreting and dealing with latch and spinlock issues, which I helped tech review, and they’ve now been published.

I strongly recommend reading these whitepapers if you want to improve your perf tuning skills beyond looking at wait statistics.

You can get them at: