Stored procedures. This is the default. When Monitor executes a stored procedure to archive or delete audit data, the database performs the entire archive or delete without further interaction from Monitor. To use stored procedures to perform an archive, the audit data must be archived to the same database where the stored procedure is located. Archiving using stored procedures is an asynchronous operation and should have little system impact. Stored procedures are especially useful for preserving Integration Server resources in high-volume situations.

Partitioning. For more information about archiving with partitioning, including configuration, see Overview of Using Partitions for Process Audit Log Data.