Page History
...
Select this filter to help identify logins that may have inappropriate access rights or permissions. This filter may also help reduce the size of your audit data.
| Type of Event Filter | Description |
|---|---|
| Audit only actions that passed access check | Omits events that track failed access checks performed by SQL Server |
| Audit only actions that failed access check | Omits events that track passed access checks performed by SQL Server |
Capture SQL statements for DML and SELECT activity
...
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 > > |
...
| Products | Buy | Support | Community | About Us | Resources | Legal