Hi,
Is there any mechanism within Laserfiche that automatically shrinks the Audit Trail database?
We’re seeing that a shrink operation is being executed on the audit database each hour? Is that normal?
This is for version 9.
Thanks.
Hi,
Is there any mechanism within Laserfiche that automatically shrinks the Audit Trail database?
We’re seeing that a shrink operation is being executed on the audit database each hour? Is that normal?
This is for version 9.
Thanks.
Audit Trail does run a shrink background process every other hour reference this post. Depending on the load of the SQL Server that host the Audit Trail database, it might be resource intensive. We are looking into customize the ability to select when to schedule the shrink database process through UI , although there is no ETA when this feature will be available. If you are experience any issue, I suggest to move the Audit Trail database to a separate SQL instance, so it doesn't affect performance
We are seeing the same logs. But strangely we only noticed this since last week.
Is there any way to change the schedule even if is not through UI?
Thanks
Gian
Version 10 of Audit Trail lets you turn shrinking off in the config XML file. Under the AuditDBServiceConfiguration node you can put:
<Maintenance AutoShrink="false" />
Other than turning it on or off, there is no scheduling functionality exposed by Audit Trail. But since we're just calling the built-in functionality of MSSQL, you should be able to use that product's automation tools to schedule shrinking.