May 2011
Intermediate to advanced
352 pages
11h 27m
English
Chapter 1. The Dynamic Management Views gold mine
Figure 1.1. Output showing if anything is blocked and what individual SQL queries are running
Figure 1.2. Identify the slowest SQL queries on your server, sorted by duration.
Figure 1.3. Output from the missing indexes SQL
Figure 1.4. Output identifies which SQL queries are currently running on the server.
Figure 1.5. Output showing searched-for cached plans
Figure 1.6. Missing indexes details included with a 2008 cached plan
Figure 1.7. Cached plan showing cost by statement and within each statement
Chapter 2. Common patterns
Figure 2.1. Execution plan for WHERE 1 = 2
Figure 2.2. Output showing the most-used cached plans that contain the text “CREATE PROCEDURE”