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!