Page History
The Online index rebuild operation is an application that creates an index with online option .
In a few editions of SQL Servers (such as STANDARD edition) the index creation with the ONLINE property is not supported and the operation results in failure message displayed to the user, instructing to run the application manually without the ONLINE property.
User can run the utility manually with additional parameters to build the indexes without the ONLINE option as follows:
<installdir>\SQLcomplianceIndexUpgrade.exe "server=serverName; database=SQLcompliance; integrated security=SSPI; Connect Timeout=30;” “ONLINE=OFF”
The second parameter “ONLINE=OFF” is an optional parameter and is to be used only when the index update operation cannot be performed with the ONLINE option.
| 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. |
Update Indexes window confirms whether you want to update indexes in the selected Repository databases now or later. Updating indexes optimizes performance when viewing and managing event data.
...
Also be aware that this update process may be resource-intensive and may take some time to complete. Consider performing database updates during non-peak hours.
Available actions
Update now
Click Yes to update the indexes in all available Repository databases, including event and archive databases.
Update later
...
.