This chapter is from the book
Quite a few resources deal with SQL Server blocking. Here is a sampling of some resources:
- Microsoft SQL Server Books Online. The descriptions of wait types and latch types are improving with every web release. The DMV documentation is also worth looking at.
- SQL Server Storage Engine Blog (http://blogs.msdn.com/sqlserverstorageengine/default.aspx)
- MSDN blogs in general (http://blogs.msdn.com—search for SQL and Blocking)
- The Guru’s Guide to SQL Server Architecture and Internals, by Ken Henderson