Enabling auditing for SAS® Visual Analytics environments can cause performance-related issues on your SAS® Web Application Server Java Virtual Machine (JVM) if the SAS audit tables in the Web Infrastructure Platform database reach an unmanageable size. You can use the following suggestions to help you manage the audit tables.
SAS Visual Analytics 7.3 comes with archive rules enabled, by default, for SAS audit tables. The default archive schedule starts every Monday at the beginning of the day. This means that the records are moved once a week from the SAS_AUDIT table into the SAS_AUDIT_ARCHIVE table and from the SAS_AUDIT_ENTRY table into the SAS_AUDIT_ENTRY_ARCHIVE table. Archive rules are important because they keep the SAS_AUDIT and SAS_AUDIT_ENTRY tables at a manageable size, which helps avoid performance-related issues on SASServer1_1. If you use a release of SAS Visual Analytics earlier than 7.3, the archive schedule is not enabled by default. You need to enable the archive schedule by adding a JVM option to the SAS Web Application Server instance(s). For more information, see the section "Archive Process for Audit Records ("Chapter 7: Administering the SAS Web Infrastructure Platform") in SAS® 9.4 Intelligence Platform: Middle-Tier Administration Guide.
Once archive rules are set up, you should periodically purge records in the audit archive tables. You can purge the tables manually by following the instructions in the section "Purging Audit Records ("Chapter 7: Administering the SAS Web Infrastructure Platform") in SAS® 9.4 Intelligence Platform: Middle-Tier Administration Guide. Or you can download this script to purge records from the archive tables.
For more information about best practices regarding the SAS audit tables and the archive process, see the following documentation: