Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Change Auditor for SQL Server 7.4 - User Guide

Introduction

SQL Server Extended Events allow users to gather information on the performance of their SQL database. Separate SQL Extended Events auditing templates must be defined for each SQL Server instance to be audited by Change Auditor.

* 
NOTE:  
•
A Change Auditor SQL Server license is required for SQL Extended Events auditing.
•
Managing SQL Extended Events auditing templates is only available to Change Auditor administrators or users that hold a custom Change Auditor role that includes the View_SQL_Template operation.

SQL Extended Events Auditing templates

To enable SQL Extended Events auditing in Change Auditor, you must create an auditing template. SQL Extended Events templates are created and managed through PowerShell commands. See the Change Auditor PowerShell Command User Guide for details.

The following Change Auditor facilities and events are available for SQL Extended events auditing.

Facility Name
Event Class

Admin Extended Events

Audit SQL Server Admin Extended Event

Analytic Extended Events

Audit SQL Server Analytic Extended Event

Operational Extended Events

Audit SQL Server Operational Extended Event

* 
NOTE: Debug channel events are not supported.

 

 

 

 

 

SQL Searches/Reports

•
Introduction
•
Create custom SQL searches
•
Create custom SQL Data Level searches
•
Create custom SQL Extended Events searches (Preview)

Introduction

You can search, report and alert on changes to all SQL instances being audited or changes made to a specific SQL instance, SQL database, or SQL Server object.

 

* 
NOTE: As a best practice, you should not have both SQL and SQL Data Level subsystems defined in a single search. When the SQL subsystem is included without filters, all SQL Data Level events will be included.
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation