the SQL server C2 audit mode
Posted on 2012-09-19
As I know that there are SQL server C2 audit mode we can turn on to log information goes beyond server-level events, such as shutdown or restart, successful and failed login attempts, extending it to successful and failed use of permissions when accessing individual database objects and executing all Data Definition, Data Access Control, and Data Manipulation Language statements.
Anyone turn it on before and how is it after using this?
I know the log will growth faster and the disk can be full easly, can we configure the C2 mode to save informatoin like insert/update/delete to other location ?
it only introduce the performance impact of the SQL server?