It’s finally ready! For the last two years, I’ve been working on-and-off on a new community resource. It was postponed during 2015 while I mentored 50+ people, but this year I’ve had a bunch of time to work on it. I present to the community a comprehensive library of all wait types and latch classes that […]
Paul S. Randal
In Recovery...
Announcing the comprehensive SQL Server Wait Types and Latch Classes Library
Posted on: May 9, 2016 7:50 am
Most common latch classes and what they mean
Posted on: August 21, 2012 12:24 pm
(Check out my Pluralsight online training course: SQL Server: Performance Troubleshooting Using Wait Statistics and my comprehensive library of all wait types and latch classes.) Back in May I kicked off a survey about prevalent latches on SQL Server instances across the world (see here). It’s taken me quite a while to get around to collating and […]
Survey: most prevalent latch waits (code to run)
Posted on: May 10, 2012 2:26 am
I first started blogging about latches and some of the deeper parts of SQL Server internals last year (see Advanced performance troubleshooting: waits, latches, spinlocks) and now I’d like to pick up that thread (no scheduling pun intended :-)) and blog some more about some of the common latches that could be a performance bottleneck. […]
New whitepapers on latches and spinlocks published
Posted on: July 1, 2011 8:13 am
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 […]
Advanced SQL Server performance tuning
Posted on: April 13, 2011 7:32 am
(Check out my Pluralsight online training course: SQL Server: Performance Troubleshooting Using Wait Statistics and my comprehensive library of all wait types and latch classes.) It’s all very well having whizz-bang 3rd-party performance monitoring and troubleshooting tools, but sometimes you have to get deeper into what’s going on with SQL Server than any of these tools can […]
TechNet Magazine: May 2010 SQL Q&A column
Posted on: May 9, 2010 12:46 pm
The May edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's topics are: How to change the file locations for a user database The difference between page latches and page I/O latches Why database snapshots are not a good substitute for […]
