Usage Note 58599: Managing SAS® audit tables
 |  |  |  |
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.
Enable Archive Rules for the SAS® 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 the SAS® 9.4 Intelligence Platform: Middle-Tier Administration Guide.
Periodically Purge Records in the SAS® Audit Tables
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 the SAS® 9.4 Intelligence Platform: Middle-Tier Administration Guide. Or you can download this script to purge records from the archive tables.
See Also
For more information about best practices regarding the SAS audit tables and the archive process, see the following documentation:
- "Configuring Auditing for SAS Web Applications" ("Chapter 7: Administering the SAS Web Infrastructure Platform") in SAS® 9.4 Intelligence Platform: Middle-Tier Administration Guide, Fourth Edition
- "Key Actions Auditing" ("Chapter 3: Security") in the SAS® Visual Analytics 7.3: Administration Guide
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Infrastructure Platform Data Server | Solaris for x64 | 9.4 | 9.4 TS1M0 | ||
| Linux for x64 | 9.4 | 9.4 TS1M0 | ||||
| HP-UX IPF | 9.4 | 9.4 TS1M0 | ||||
| 64-bit Enabled Solaris | 9.4 | 9.4 TS1M0 | ||||
| 64-bit Enabled AIX | 9.4 | 9.4 TS1M0 | ||||
| Windows 7 Professional x64 | 9.4 | 9.4 TS1M0 | ||||
| Windows 7 Enterprise x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 Std | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 R2 Std | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 for x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 R2 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 10 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Pro x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8 Pro x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8 Enterprise x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft® Windows® for x64 | 9.4 | 9.4 TS1M0 | ||||
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2016-07-29 07:55:52 |
| Date Created: | 2016-07-12 13:46:24 |