Page History
The Online index rebuild operation is an application that upgrades indexes in the background and converts Indexes from none compression to a page level compression type. This operation updates indexes on the Events table in each of the monitored instance databases to become page compressed type. The operation is performed as an ONLINE operation (only for supported SQLServer versions) keeping the database table(s) available for users. This This index upgrade shows considerable performance advantage and optimizes performance when viewing and managing event data.
...
- IX_Events_eventId
- IX_Events_eventCategory
- IX_Events_eventType
- IX_Events_databaseId
- IX_Events_appNameId
- IX_Events_hostId
- IX_Events_loginId
The operation is performed as an ONLINE operation (only for supported SQLServer versions) keeping the database table(s) available for users. The process first application checks the SQL Server version and then checks if the index compression type is set to page or none. On the basis of the compression type it performs the Index upgrade query ONLINE for compression to page type. The process then creates the non existing 7 indexes mentioned above, after creation it performs the compression on the 7 indexes of the event databases (for each instance added for
auditing). For new instances, it will create the page compressed type indexes by default.
| Info |
|---|
The index upgrade operation is skipped if the compression type is already of page type. |
...
In a few SQL Servers versions (such as the STANDARD edition), the index creation with the ONLINE property is not supported and therefore the operation results in a failure message displayed to the user, instructing to run the application manually without the ONLINE property.
...