May 2011
Intermediate to advanced
352 pages
11h 27m
English
Chapter 1. The Dynamic Management Views gold mine
Chapter 2. Common patterns
Chapter 3. Index DMVs
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