Troubleshoot waiting and blocking issues in SQL Server 2005

Waiting and blocking, two of the most common problems SQL Server users encounter, can touch many aspects of SQL Server, so any investigation of them benefits from a solid understanding of how SQL Server works. Conversely, studying waiting and blocking is a good way to learn even more about the server. In this sample chapter from SQL Server 2005 Practical Troubleshooting: The Database Engine, take a brief architectural overview of relevant SQL Server components, then drill down into waiting and blocking and acquire the tools and knowledge you need to resolve waiting and blocking issues. Chapter coverage includes:

• Wait types
• Troubleshooting blocking
• Identifying blocking
• Identifying the cause of blocking
• Resource type specifics
• Deadlocks
• Monitoring blocking
• Other resources

Title: SQL Server 2005 Practical Troubleshooting: The Database Engine
ISBN: 0321447743
Published: December 2006
Author: Ken Henderson
Chapter: Chapter 1: Waiting and Blocking Issues
Published by Addison Wesley Professional