Report inactive indexes
-
I was looking through ProTop and was somewhat surprised to find that it doesn't seem to report inactive indexes anywhere. Just wondering whether that has been considered as a feature, e.g. as a counter (# of inactive indexes) in the configuration panel.
Given the performance problems that an inactive index could cause, it would be useful to alert if this number was non-zero (perhaps excluding audit indexes).
-
I have added this to the backlog. Thanks for the idea.
-
For reference, the non-essential audit indexes (which are often purposely deactivated, except in audit archive DBs):
_aud-audit-data._AppContext-Id
_aud-audit-data._Connection-id
_aud-audit-data._Event-context
_aud-audit-data._Event-group
_aud-audit-data._EventId
_aud-audit-data._Userid
_aud-audit-data-value._Field-name -
Which reminds me of another needed alert "not having audit archive db"
