You can configure how the SQL Compliance Manager Agent manages trace files. These settings include file size thresholds and how often the SQL Compliance Manager Agent calls the Collection Server with a heartbeat.
If you specify a different location for the trace directory, ensure the 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 Compliance Manager applies this change to the active node in the cluster hosting the virtual SQL Server. 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:
- Navigate to Registered SQL Servers in the Administration tree.
- Select the SQL Server instance that hosts the SQL Compliance Manager Agent you want to check.
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 - To designate a different folder for the SQL Compliance Manager Agent trace directory, complete the following steps:
- Go to the Administration tab > Registered Servers.
- Select the server you want to make changes, right-click on it, and select Change Agent Trace Directory.
- Specify the path for the new agent trace directory location.
- Click OK.