Data Auditing provides a simple way to track and log events relating to your databases and servers. You can audit logons, password changes, data access and modification, and many other events. Tracking these events helps maintain security and can also provide valuable troubleshooting information. The results of audits can be saved to file or to the Windows Security or Application logs for later analysis or archiving.
Enables compliance with security regulations
Simple configuration using SQL Server Management Studio
Minimal impact on performance because audit data is stored outside of SQL Server database files