SQL Server DMVs in Action

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 ...