Specifies the maximum number of rows that can be stored in the in-memory audit table.

データ型

string

デフォルト値

"1000"

解説

When auditing is enabled using the AuditMode property, AuditLimit controls how many rows are retained in the audit table at one time.

By default, this property is set to 1000, meaning only the 1000 most recent audit events are preserved. Older entries are removed as new ones are added.

To disable the limit and retain all audit rows, set the property to -1. This may significantly increase memory usage. In that case, clear the audit table periodically to manage resource consumption.

You can clear the audit table using a command like:

DELETE FROM AuditJobs#TEMP

Adjust this property based on your logging needs and available memory. Use higher values or disable the limit only if you plan to manage audit data manually.