Useful Statistics to Monitor
|
Statistic |
Meaning |
Possible action |
|---|---|---|
|
Orphan count |
Indicates the number of orphaned SR8 records. |
Tune or rebuild the index if more than 25% of the member records are orphaned. |
|
Index levels |
Indicates the number of levels in the index. |
Tune or rebuild the index if the number of levels exceeds the number originally calculated |
|
SR8 split |
Indicates the number of SR8 splits. |
If the number of SR8 splits is high, determine if applications frequently insert a large group of index entries in one spot; tune or rebuild the index to balance it and cleanup orphan index records. |
Where the Statistics are Reported
|
Copyright © 2014 CA.
All rights reserved.
|
|