Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The online index rebuild operation is an application that upgrades indexes in the background and converts them from a none compression state into a page level compression type. This operation updates indexes on the Events table in the databases on each of the monitored database instance to become a page compressed type. This index upgrade shows considerable performance advantage advantages and optimizes performance when viewing and managing event data.

The following 7 Indexes are included to in the Events table of an a monitored instance being audited:

  • IX_Events_eventId
  • IX_Events_eventCategory
  • IX_Events_eventType
  • IX_Events_databaseId
  • IX_Events_appNameId
  • IX_Events_hostId
  • IX_Events_loginId

...