What is Auditing Inside SQL Server ?
SQL Server Audit offers features that help DBAs achieve their goals of meeting regulatory compliance requirements. SQL Server Audit provides centralized storage of audit logs and integration with System Center. SQL Server Audit was designed with the following primary goals in mind..
- Security - The audit feature, and its objects, must be truly secure.
- Performance - Performance impact must be minimized.
- Management - The audit feature must be easy to manage.
- Discoverability - Audit-centric questions must be easy to answer.