asked
Why C2 Audit tracing ?
Let me know what will do with c2 audit enable? And when this enable sql server performance going down why is that ? How to enable c2 audit tracing without effecting to sql server performance?
C2 Auditing is a very intense audit, keeping logs of every insert, update and delete as well as logins. This is also why there is a performance hit when this is enabled. Not only is there CPU/memory hits, but disk io as well. Here is a good article that will give you the basics of C2 auditing -
http://www.sqlservercentral.com/articles/Monitoring/basicsofc2auditing/1547/ There is not anything that you can do to reduce the performance hit if you are using C2 auditing. Steve
18 People are following this question.
