August 11, 2010 at 5:59 am
Is there are issue if I enable C2 Audit in SQL Server 2005. Any otherthings needs to be considered?
any performance impact on sqlserver or db access.
For any reason if server is unable to write the audit log, does database become inaccessible for users.
Is it recommended to enable C2 Audit in production server.
August 11, 2010 at 9:27 am
Here is the note from MSDN
C2 audit mode saves a large amount of event information to the log file, which can grow quickly. If the data directory in which logs are being saved runs out of space, SQL Server will shut itself down. If auditing is set to start automatically, you must either restart the instance with the -f flag (which bypasses auditing), or free up additional disk space for the audit log
More details here
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply