Page History
...
When Extended Events mode is enabled, events generate XEL files instead of trace files (.xel rather than .trc) but the files still are located in the Agent trace directory.
There are two three ways to enable Extended Event capture:
- a Through stored procedureprocedures.
- Through the Manage Instance Properties - Audited Activities tab in the Web Console.
- the
Through the
Registered SQL Server Properties window - Audited Activities tabin the Windows Management Console.
the Web consoleNote 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.
Anchor SQL4942 SQL4942 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
Prerequisites and conditions for enabling auditing using Extended Events
...
Users wanting to take advantage of SQL Server Extended Events auditing capabilities can do so by completing the following steps:
- In your IDERA SQL Compliance Manager Dashboard menu, Select the Instances tab.
- Click the gear icon in the Options column for the instance you want to audit and select Properties (instance).
- Select the Audited Activities tab.
- Under the Capture DML and Select activities options, select the Via Extended Events option to enable Extended Events auditing.
- Click OK.
For more information about enabling this feature using the Web Console, see Manage Instance Properties - Audited Activities tab.
Enable Extended Event mode using the Windows Management Console
Users wanting to take advantage of SQL Server Extended Events auditing capabilities can do so by completing the following steps:
- Right-click the instance you want to audit and select Properties.
- In the Registered SQL Server Properties window, select the Audited Activities tab.
- Under the Capture DML and Select activities options, select the Via Extended Events option.
- Click OK.
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 Windows Management Console, see Registered SQL Server Properties window - Audited Activities tab.
Scroll pdf ignore |
---|
SQL Compliance Manager audits all activity on your server. Learn more > > IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |
Scroll Pagebreak |
---|