ECM Database size

ECM
1

I have noticed that our ECM Database is getting quite large.

I know that there are a huge number of variables here in terms of number of documents fields / index data etc. but I ran a data usage report and it transpires that this is almost entirely due to audit data.

We have never touched the Audit settings, and so are probably auditing way too much or at least a lot of stuff that is not relevant.

So…bit of an open question here (everyone has different needs) but any suggestions as to what should / should not be audited?

I am thinking I will turn off the Level 3 and Level 4 audit entries anyway as it suggests these are optional and will see what difference this makes.

2

We’ve never needed to look at the audit records - but now that I’ve admitted that… :person_shrugging:

I’d turn the level 3/4 off and delete audit records based on age. SQL should get that space back and with your periodic maintenance plan, it should shrink the DB file.

1 Like