Versions Compared

Key

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

...

The operation is performed as an ONLINE operation (only for supported SQLServer SQL Server versions) keeping the database table(s) available for users. The application checks the SQL Server version and then checks if the index compression type is set to page or none. On the basis of based on the compression type, it performs the Index upgrade query which is set to be an ONLINE operation for any compression type to page compression type.   The process operation then creates runs and converts 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) to be page compressedFor For environments with large repositoryrepositories, the index rebuilds can take a significant amount of time. If you need to defer the rebuild, the SQL Compliance Manager update process will proceed without rebuilding the indexes and you can choose to rebuild the indexes do so at a later. For new instances, it creates the page compressed type indexes is created by default.

Info

The index upgrade operation is skipped if the compression type is already of set to page compression type. 

Manually run the Index rebuild operation

...