Database Indexes
The metrics in this category provide information about each clustered index, one row for each nonclustered index, one row for each table that has no clustered index, and one row for each table that contains text or image columns.This table also contains one row for each function-based index or index created on a computed column.
Collection Frequency - Every 24 hours
Table 4-12 Database Indexes Metrics
| Metric | Description and User Action |
|---|---|
|
Creation date |
Creation date. |
|
Character set ID |
Character set ID with which the index was created; 0 if there is no character data in the keys. |
|
Index ID |
ID of an index, or ID of table to which index belongs. |
|
Number of keys for a clustered index |
Number of keys for a clustered index on an allpages-locked table; number of keys, plus 1 for all other indexes. The upload frequency is after every sample. The operator is >. For this metric, you can set different warning and critical threshold values for each "Index/Table Name" object. If warning or critical threshold values are currently set for any "Index/Table Name" object, those thresholds can be viewed on the Metric Detail page for this metric. To specify or change warning or critical threshold values for each "Index/Table Name" object, use the Edit Thresholds page. |
|
Maximum size of a row |
Maximum size of a row. |
|
Maximum number of rows per page |
Maximum number of rows per page. |
|
Minimum size of a row |
Minimum size of a row. |
|
For Release 6 Partition Type |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) \1 - range 2 - hash 3 or NULL - [default] round robin 4 - list |
|
Segment number |
Number of segment in which object resides. |
|
Sort order ID |
Sort order ID with which the index was created; 0 if there is no character data in the keys. |
|
Index/Table Name |
The name of an index, or the name of a table to which the index belongs. |
|
Total Size (MB) |
Total size of the index. |
|
Used Space (MB) |
Space used by the index. |
|
Free Space (MB) |
Free space in the index. |
|
Space Utilization (%) |
Percentage of database index space utilization. |