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:
- Diagnosing and Resolving Latch Contention on SQL Server
- Diagnosing and Resolving Spinlock Contention on SQL Server