I have a strange problem with a simple notes db (ODS 51) while the count of the number of documents is the same , the db size is growing from 7 GB to 25 GB in 2 weeks. Users activities are to read or update existing documents.The db has 40 mb of attachments and 3mb of view indexes.
What could cause the db growth and how i can analyze the problem?
Subject: white space?
check the white space. in db properties on the info tab press the % Used button, if the result is a low # then you need to compact the db. Is the db full text indexed? If so this is included in the db size. I doubt white space is the issue unless the db gets a great deal of deletions.
Subject: Db Size
The db is compacted daily. There is no deletion in the db only reads and updates. The db has 99,9% used.The db has no full text index.I removed all unused views and recreated index for active views. No changes , the db is growing almost 1 GB per day
Subject: new copy
make a new local replica (or copy). Is the new copy about the same size? If so then take a look at the documents getting created and see what the size of them are. Build a view to show this so you can see where the problem is.
Subject: DB copy
A new replica of this db is significantly smaller.I’ve replaced the server db with a new replica that it was 7Gb , a week later db is 12 Gb. During this week 107 users used db only to read docs