SQL Server auditing is a new feature which makes use of extended events to allow you to audit everything that happens in your server, from server setting changes all the way down to who modified a value in a specific table in the database.

What is the purpose of a database audit?

Auditing your databases enables you to track and understand how your records are used and gives you visibility into any risks of misuse or breaches. When you conduct an audit, you can monitor each interaction with the data and log it to an audit trail.

Which components are part of SQL Server audit?

• The SQL Server Audit feature (required)
• The Database Audit Specification (optional)
• The Server Audit Specification (optional)