Versions Compared

Key

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

You can groom audited SQL events from the event databases in the Repository. When you groom audit data, SQL compliance manager SQL Compliance Manager deletes all events that are older than the age (in days) you specify. You can groom audit data collected from all registered SQL Server instances or from selected instances. Grooming ensures the Repository contains only the audit data you need.

...

You can groom events using the Management Console or the CLI. Note that SQL compliance manager SQL CM does not automatically shrink the Repository databases after a groom is performed. After each groom operation, re-index and shrink the affected Repository databases so that SQL Server can reclaim the space that had been allocated due to the previous growth.

...