jharrel

How to fully disable AF auditing?

Discussion created by jharrel on Jul 5, 2012
Latest reply on Jul 6, 2012 by pcombellick

Reporting from our AF 2010 R3 environment recently came so a near shutdown because of AF auditing.  More specifically, there were 85 million records in the FindChanges_AT table, which is an AF auditing table.  This caused a major slowdown in the sql server database.  When i run afdiag.exe or the function "dbo.isAuditEnabled", it shows that auditing is disabled...obviously, this isnt the case.  Has anyone else experienced this?  Is there a way to fully turn off AF auditing?  If i can't disable the auditing, my plan is to just purge the table daily. 

 

Also, it appears that AF purges records older than 30 days and i can see a stored procedure (usp_audit_findchanges_delete30days) in sql server database that does this.  How does that purge get triggered?  

 

Thanks ahead of time for your input!

 

Josh

Outcomes