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:
- Diagnosing and Resolving Latch Contention on SQL Server
- Diagnosing and Resolving Spinlock Contention on SQL Server
Enjoy!
4 thoughts on “New whitepapers on latches and spinlocks published”
Thanks very much for the links; they gave me a good kick in the right direction. I am now starting to realise that my understanding of locking has been clouded by not knowing enough about latches, and that latching is a fascinating area in itself.
I guess once you are in a position where detailed spinlock analysis is a relevant option though, you’re probably running the kind of system where "standard temperature and pressure" assumptions no longer apply. But being given a little bit of insight into SQL Server spinlock design goes a long way towards bridging the gap between Delaney and Russinovich :-)
WOW…
Just when i needed a whitepaper to figure out why i have LOCK_HASH contention :)
Thx for the links !
Whitepapers have been consolidated under a single link:
http://blogs.msdn.com/b/sqlcat/archive/2013/09/05/sqlcat-com-consolidated-index-of-whitepapers.aspx