Beginning with IDERA SQL Compliance Manager 5.4, SQL trace is deprecated as the product moves toward using SQL Server Extended Events. SQL Server Extended Events is an event handling system that offers lower overhead and delivers performance gains over the default SQL trace method. In SQL Compliance Manager 5.4, only SELECT and DML events for SQL Server 2012 and later versions are supported by this feature. All functionality that works on top of these events, such as DML/Select filtering, Before-After data, sensitive column auditing, and more, work with this new method of capturing event data.
There are two ways to enable Extended Event capture:
- a stored procedure
- the Registered SQL Server Properties window Audited Activities tab in the Web console
Enable using stored procedures
To enable Extended Event mode using stored procedures, go to the location where the IDERA SQL Compliance Manager Console application is installed, and then execute the stored procedure
[dbo].[sp_enable_ExtendedEvents]
EXEC [dbo].[sp_enable_ExtendedEvents] <SERVER_NAME>,<YES/NO>
Enable using the Web Console
Users wanting to take advantage of SQL Server Extended Events auditing capabilities can do so on the Privileged User auditing tab of the Registered SQL Server Properties window Audited Activities tab by selecting Capture DML and SELECT activities using SQL Extended Events.