Page History
The Online index rebuild operation is an application that creates an index with online option that upgrades indexes in the background and converts Indexes from none to 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 index upgrade shows considerable performance advantage and optimizes performance when viewing and managing event data.
In a few editions of 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.
Before updating the indexes, ensure the selected database has sufficient free space to accommodate these changes. For example, if the current database is 1MB in size, the updated database may grow to 2 MB. In this case, the update process would require 1MB of free space.
User can run the utility manually with additional parameters to build the indexes without the ONLINE option as follows:
...
| Note |
|---|
This operation should only be done during a downtime, since the index creation will acquire a lock on the Events table and the auditing will not work in that duration. |
Updating indexes optimizes performance when viewing and managing event data.
Before updating the indexes, ensure the selected database has sufficient free space to accommodate these changes. For example, if the current database is 1MB in size, the updated database may grow to 2 MB. In this case, the update process would require 1MB of free space.
...
. |