Use these configuration parameters to manage the auditing process:
auditing – enables or disables auditing for the entire Adaptive Server. The parameter takes effect immediately upon execution of sp_configure. Auditing occurs only when this parameter is enabled.
audit queue size – establishes the size of the audit queue. Because the parameter affects memory allocation, the parameter does not take effect until Adaptive Server is restarted.
suspend audit when device full – controls the behavior of the audit process when an audit device becomes full. The parameter takes effect immediately upon execution of sp_configure.
current audit table – sets the current audit table. The parameter takes effect immediately upon execution of sp_configure.