You are viewing limited content. For full access, please sign in.

Question

Question

Audit Trail Database

asked on March 2, 2016 Show version history

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.

0 0

Replies

replied on March 2, 2016

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

3 0
replied on March 2, 2016

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

0 0
replied on March 2, 2016

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.

2 0
You are not allowed to follow up in this post.

Sign in to reply to this post.