This metric category provides information about index operations.
Default Collection Interval — Every 60 minutes
Table 1-43 Index Usage Metrics
Metric | Description |
---|---|
Database Name |
Name of the database. |
Database ID |
Database identifier |
Table or View Name |
Name of the table or view. |
Table or View ID |
Identifier of the table or view. |
Index Name |
Name of the index. |
User Seeks per second |
User Seeks per second. |
User Scans per second |
User Scans per second |
User Lookups per second |
User Lookups per second |
User Updates per second |
User Updates per second |
System Seeks per second |
System Seeks per second |
System Scans per second |
System Scans per second |
System Lookups per second |
System Lookups per second |
System Updates per second |
System Updates per second |
Total Operations per second |
Total Operations per second |