Versions Compared

Old Version 9

changes.mady.by.user Nicolas Rios

Saved on

compared with

New Version 10

changes.mady.by.user Nicolas Rios

Saved on

Key

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

...

The operation is performed as an ONLINE operation (only for supported SQLServer 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 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  For large repository, index rebuilds can take a significant amount of time. If you need to defer the rebuild, the SQL Compliance Manager update process will proceed and you can choose to rebuild the indexes later. For new instances, it will create creates the page compressed type indexes by default.

...