List of Tables

Chapter 1. The Dynamic Management Views gold mine

Table 1.1. The major DMV groups

Chapter 2. Common patterns

Table 2.1. Common terms and their meaning

Chapter 3. Index DMVs

Table 3.1. Types of indexes

Table 3.2. Types of index access

Table 3.3. DMVs used to find missing indexes

Table 3.4. DMV/system tables to identify the most-costly unused indexes

Table 3.5. DMVs/system tables to identify the top high-maintenance indexes

Table 3.6. DMV/system tables to identify the most-used indexes

Table 3.7. DMV/system tables to identify the most-fragmented indexes

Table 3.8. DMV/system tables to identify the index usage

Table 3.9. DMV to identify the databases with the most missing indexes

Table 3.10. DMV/tables to identify unused indexes

Table 3.11. The state of your statistics

Chapter 4. Improving poor query performance

Table 4.1. DMV/DMFs to find a cached plan

Table 4.2. DMV/DMFs used to identify where a query is used.

Table 4.3. DMV/DMFs to identify the queries that take the longest time to run

Table 4.4. Percentage waiting and cause of slowness

Table 4.5. DMV/DMFs to reveal the queries that take the longest time being blocked

Table 4.6. DMV/DMFs to identify the queries that use the most CPU

Table 4.7. DMV/DMFs to identify the queries that use the most I/O

Table 4.8. DMV/DMFs that identify the queries that are executed most often

Table 4.9. DMV/DMF to identify when a query was last run

Chapter 5. Further query improvements

Table 5.1. DMV/DMFs to identify the queries that contain missing statistics