SharePoint Secure Store Audit Management

Have you ever experienced uncontrolled growing size of SQL Server Data Drive for a SharePoint Environment? If yes, the below could be the reason.

There is a data base in SharePoint environment whose name started with “Secure_Store_Service_DB_”

In that database there is a table called SSSAudit, which keep growing if the Audit is enabled.

There can be 2 way to control this.

1.   Disable the Auditing Feature
2.   Change the Purge frequency

These above configuration is available in a table called SSSConfig

Which can be updated by simple SQL Query.

 

  UPDATE dbo.SSSConfig SET EnableAudit = 0

 

  UPDATE dbo.SSSConfig SET PurgeAuditDays = 10