You can test your audit settings whenever you apply a change. Testing helps ensure you collect the audit data you need to maintain continuous compliance with internal and external standards.
To test your audit settings:
- Navigate to Registered SQL Servers in the Administration tree.
- Select the SQL Server instance on which you want to test your audit settings.
- Ensure the SQL Compliance Manager Agent for the target SQL Server instance is using your most recent audit settings.
- On the Auditing menu, click Collect Audit Data. This action will collect SQL Server events based on your current auditing settings.