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”
Figure 2.3. Results of running DMV delta code given in listing 2.8
Figure 2.4. Cached plan showing cost by statement and within each statement
Figure 2.5. Cached plan identifying a missing index
Figure 2.6. Cached plan identifying a missing column statistics
Figure 2.7. Cached plan identifying a table scan
Figure 2.8. Cached plan identifying an index lookup
Figure 2.9. Cached plan shown as XML, identifying an implicit data type conversion
Chapter 3. Index DMVs
Figure 3.1. Output showing the fill factor of indexes
Figure 3.2. Output showing the summary statistics for the index IX_Deal_5
Figure 3.3. Output showing the fragmentation percentage of indexes
Figure 3.4. Output showing the most important missing indexes
Figure 3.5. Output showing the most-costly unused indexes