IDERA SQL Compliance Manager 5.5 and later allows you to take advantage of the SQL Server Audit Logs feature to track specific events occurring in your monitored environment. SQL Server Audit Logs is an event handling system that helps you reduce the size of data gathered and deliver performance gains over the default SQL trace method. In SQL Compliance Manager 5.5 and later, only SELECT and DML events for SQL Server 2017 and later versions are supported by this feature.
Capturing DML and SELECT activities via Audit Logs does not include the following features:
To enable capturing events via Audit Logs go to:
IDERA SQL Compliance Manager supports Audit Logs based auditing for SQL Server 2017 and above. The following prerequisites and conditions are required to switch auditing based on Audit Logs.
Users wanting to take advantage of SQL Server Audit Logs auditing capabilities can do so by completing the following steps:
For more information about enabling this feature using the Windows Management Console, see Registered SQL Server Properties window - Audited Activities tab.