list-of-figures

List of Figures

 

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