The SQL Compliance Manager Agent manages the SQL trace that collects audit data. If the SQL trace is stopped, modified, paused, or deleted by another application, the SQL Compliance Manager Agent restarts the trace and checks the trace status. The Collection Server then logs an event indicating the current trace status.

You can set the trace tamper detection interval from the SQL Compliance Manager Agent Properties window. For more information, see Configure how the SQL Compliance Manager Agent manages trace files.  

If an issue has occurred, one of the following events will display on the Agent Events tab of the SQL Compliance Manager Activities tab.

This Agent Event …Means …
Trace stoppedThe SQL trace was stopped but still exists on the audited SQL Server instance.
Trace missingThe SQL trace that was running no longer exists on the audited SQL Server instance. The SQL Compliance Manager Agent started a new trace.
Trace alteredA SQL trace setting was altered.



 |   |  |  |  |