Chapter 1. Waiting and Blocking Issues

By Santeri Voutilainen

In This Chapter

• Wait Types

• Troubleshooting Blocking

• Identifying Blocking

• Identifying the Cause of Blocking

• Resource Type Specifics

• Deadlocks

• Monitoring Blocking

• Conclusion

• Other Resources

I will start this chapter on blocking by talking about waiting. Why would I start a chapter on blocking with waiting? Well, the two are very much related, and they are often treated as synonyms. Because they are so related, the SQL Server concepts and tools related to each are intermingled; therefore, it is important to distinguish one from the other.

Conceptually, waiting usually refers to an idle state in which a task is waiting for something to occur before continuing execution. ...

Get SQL Server 2005 Practical Troubleshooting: The Database Engine now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial