Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Report inactive indexes

    Roadmap
    2
    4
    4540
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Rob Fitzpatrick
      Rob Fitzpatrick last edited by

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

      1 Reply Last reply Reply Quote 0
      • tom
        tom administrators last edited by

        I have added this to the backlog. Thanks for the idea.

        1 Reply Last reply Reply Quote 0
        • Rob Fitzpatrick
          Rob Fitzpatrick last edited by

          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

          tom 1 Reply Last reply Reply Quote 0
          • tom
            tom administrators @Rob Fitzpatrick last edited by

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

            1 Reply Last reply Reply Quote 0
            • First post
              Last post