I am right now tried to turn on the C2 audit feauture of SQL server 2008 R2 but there is one more feature since SQL 2008 that called SQL server Audit and it is hightly customerizable.
what is the way to turn it on and off? any pre and post configuraiton needs to be done?
is that following link for SQL server 2008 R2:?
The C2, which use SQL trace, will create too much workload? any example on real world on how much the SQL server degraded?
Any restart needed after tunning on both:
1) C2 audit
2) SQL audit