17.4. Waits, queues, and DMV cross-reference

Figure 17.13 groups together relevant wait types, Performance Monitor counters, and DMVs by the appropriate resource bottleneck. This is certainly not an exhaustive list, but it's a reasonable starting point for further analysis.

Get SQL Server 2008 Administration in Action 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.