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


  • administrators

    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


  • administrators

    Which reminds me of another needed alert "not having audit archive db" 😉


 

Looks like your connection to ProTop Community was lost, please wait while we try to reconnect.