Versions Compared

Key

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

This The Audited Activities tab of the Audited Database Properties is tab allows you to change which types of SQL Server events you want to audit on the selected databases. Use the Audit Events tab to see your collected data.

...

Allows you select the type of activity you want to audit. Based on your selections, IDERA SQL Compliance Manager collects and processes the corresponding SQL Server events.

...

SQL Server instance. If the access check filter is enabled for a database on a registered instance , SQL CM Compliance Manager collects access check events at the database level.

...

Ensure the Collection Server and the target SQL Server computers have ample resources to handle the additional data collection, storage, and processing. Because this setting can significantly increase resource requirements and negatively impact performance, choose this setting only when your compliance policies require you to audit transaction status, such as rollbacks.

 

Excerpt
SQL Compliance Manager audits all activity on your server. Learn more > >