Page History

IDERA SQL Compliance Manager 5.4 and later allow allows you to take advantage of the SQL Server Extended Events (XEvents) feature to track and archive specific events occurring in your monitored environment. 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 and  later, 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 Through stored procedureprocedures.
• the Through the Registered SQL Server Properties window - Audited Activities tab in the Web consoleWindows Management Console. 

  
  

  Note
  title Extended Events captures extra Execute events
  Due to differences in how Microsoft has implemented Extended Events compared to other auditing methods, when auditing via Extended Events the user will see extra Execute events as compared to the same data captured by other auditing methods.

  Note
  title Extended Events does not Support Auditing a specific table/object
  Due to technical limitations, Extended Events does not support auditing for a specific table/object. To audit a specific table/object please audit using SQL Trace or SQL Server Audit Logs. Anchor SQL4942 SQL4942

Prerequisites and conditions for enabling auditing using Extended Events

...

EXEC [dbo].[sp_enable_ExtendedEvents] <SERVER_NAME>,<YES/NO>

Enable Extended Event mode using the

...

Windows Management Console

Users wanting to take advantage of SQL Server Extended Events auditing capabilities can do so on the Audited Activities tab of by completing the following steps:

1. Right-click the instance you want to audit and select Properties.
2. In the Registered SQL Server Properties window

...

1. , select the Audited Activities tab.
2. Under the Capture DML and

...

1. Select activities options, select the Via Extended Events option.
2. Click OK.

For more information about enabling this feature using the Web Windows Management Console, see Registered SQL Server Properties window - Audited Activities tab.