Description
Audit level. Possible values are none, success, failure, and all. Audits are written to the error log and to the Windows Event Viewer.SQL
EXEC xp_loginconfig 'audit level'
Data Type
NVARCHAR(128)Sample Value
success
Releases
Documentation
Links
More
An audit level in SQL Server determines the amount of logging and monitoring performed by the system. It defines the extent to which SQL Server tracks and records activities such as logins, permissions changes, and other security-related events. Properly configuring audit levels helps in maintaining a balance between security and performance, as high audit levels can sometimes lead to performance overhead.
Types of Audit Levels
- None: No audit logging is performed. This level is typically not recommended for production environments.
- Success: Only successful login attempts and actions are logged.
- Failure: Only failed login attempts and actions are logged.
- All: Both successful and failed login attempts and actions are logged. This provides comprehensive logging but can impact performance.