Page History

You can configure how the SQLcompliance SQL Compliance Manager Agent manages trace files. These settings include file size thresholds and how often the SQLcompliance SQL Compliance Manager Agent calls the Collection Server with a heartbeat.

If you specify a different location for the trace directory, ensure the SQLcompliance SQL Compliance Manager Agent Service account has read and write privileges on that folder. IDERA SQL Compliance Manager does not change the security settings on existing folders.

If you are auditing a virtual SQL Server, ensure the specified folder is located on a shared data disk for the specified virtual SQL Server. SQL CM SQL Compliance Manager applies this change to the active node in the cluster hosting the virtual SQL Server. SQLcompliance SQL Compliance Manager Agent properties are later replicated from the active node to the passive nodes.

To configure how the

...

SQL Compliance Manager Agent manages trace files:

1. Navigate to Registered SQL Servers in the Administration tree.
2. Select the SQL Server instance that hosts the SQLcompliance SQL Compliance Manager Agent you want to check.

3. On the Agent menu, click Agent Properties.

   If you want to …	Use this tab …
   Change heartbeat interval	General
   Change logging level	General
   Configure trace collection settings	Trace Options
   Limit trace directory size	Trace Options
   Review agent status, version, and last heartbeat time	General
   Review current trace directory path	Trace Options
   Review how the agent was deployed on this SQL Server instance	Deployment
   Review which SQL Server instances the agent audits	SQL Servers
   Set how long the agent can run unattended	Trace Options
   Set how long the agent waits before restarting a SQL trace that is stopped, modified, paused, or deleted	Trace Options
   Verify agent service account	Deployment

4. If you want to To designate a different folder for the SQLcompliance SQL Compliance Manager Agent trace directory, complete the following steps.
   :
   
   1. Go to the Administration tab > Registered Servers.
   2. Select the server you want to make changes, right-click on it, and select Change Agent On the Agent menu, click Change Trace Directory.
   3. Specify the path for the new agent trace directory location.
5. Click OK.

...

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

...

...