Chapter 34. What are you waiting for? An introduction to waits and queues
The purpose of this chapter is to help fellow DBAs, developers, and other database professionals by spreading the word about waits and queues. This performance-tuning methodology became significant with the release of SQL Server 2005, with all its dynamic management views and functions, collectively known as dynamic management objects (DMOs). With waits and queues, you can quickly identify the cause of a performance bottleneck on your SQL Server systems. Although this methodology was introduced without much fanfare, there wasn’t a substantial amount of early adoption by those who would benefit from it the most: database administrators.
This topic is detailed ...