Page History

...

• a stored procedure
• the Registered SQL Server Properties window Audited Activities tab in the Web console

Prerequisites and conditions for enabling auditing using Extended Events

IDERA SQL Compliance Manager supports Extended Events based auditing for SQL Server 2012 or above. The following prerequisites and conditions are required to switch auditing based on Extended Events.

• During installation
  • SQL Compliance Manager checks to make sure that Microsoft.SqlServer.XEvent.Linq.dll is available. If not, installation aborts.
• While enabling Extended Events from the web console
  • SQL Compliance Manager checks for the following conditions, which all must be met to successfully enable Extended Events:
    
    • Agent is reachable
    • SQL Server 2012 or above
    • SQL Compliance Manager Agent 5.4 or above
    • Microsoft.SqlServer.XEvent.Linq.dll is available (along with Microsoft.SqlServer.XE.Core.dll if Linq.dll is obtained from SQL Server SMO 2014 or 2016)
    Note that these conditions must be checked and confirmed manually if Extended Events is being enabled using a SQL stored procedure.

Enable Extended Event mode 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]. For example:

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

Enable Extended Event mode using the Web Console

Users wanting to take advantage of SQL Server Extended Events auditing capabilities can do so on the Audited Activities tab of the Registered SQL Server Properties window by selecting Capture DML and SELECT activities using SQL Extended Events. For more information about enabling this feature using the Web Console, see Registered SQL Server Properties window - Audited Activities tab.

IDERA Website

...

| Products | Buy | Support | Community | About Us | Resources | Legal