You can quickly check the status of a SQL Compliance Manager Agent that is deployed to a registered SQL Server instance you are auditing. This feature provides a summary of the agent health. For more detailed information to help troubleshoot an issue, see the agent properties.
To check the SQL Compliance Manager Agent status:
- 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.
- Click Check Agent Status on the Agent ribbon.
- Review the status, and then click OK. To obtain more detailed information about the agent, review the agent properties. To refresh the status displayed in the Registered SQL Servers tab, click Refresh on the View menu.
SQL Compliance Manager monitor, audit and alert on SQL user activity and data changes.
| | | | | | |