Versions Compared

Key

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

The SQL Compliance Manager Agent runs under the SQL Compliance Manager Agent Service account on each registered SQL Server computer that hosts the audited instances and databases. To audit events, the SQL Compliance Manager Agent starts SQL Server traces that run on the target SQL Server. Once a trace starts, SQLcompliance SQL Compliance Manager copies events from the SQL trace to trace files, providing a raw audit record.

Trace files are stored in the AgentTraceFiles folder under the install directory directory (C:\Program Files\Idera\SQLcompliance) on  on the computer that hosts the SQL Server instance. This folder is secured using ACL settings. You can specify a different location for the trace directory.

...

By default, the SQL Compliance Manager Agent communicates with the Collection Server every 5 minutes. This communication is a heartbeat. During a heartbeat, the SQL Compliance Manager Agent confirms its health and receives audit setting updates. You can manually apply audit setting updates as needed using the Management Console.

Note
titleNOTE

Anchor
SQLCM-5450
SQLCM-5450
During the heartbeat, the Collection Service requests a list of the Database Names and ID´s in order to update the table stored in the event database.

If the SQL Compliance Manager Agent continues to run without a heartbeat, IDERA SQL Compliance Manager considers the agent to be unattended. By setting the unattended time limit, you can control how long traces are allowed to run until SQL Server stops the trace. Use this setting to automatically stop auditing when the SQL Compliance Manager Agent is not responding or is deleted.

...

Scroll pdf ignore

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

IDERA Website | Products Buy Support Community About Us | Resources Legal

...