We have a domino 7.0.2 application server running some sales and marketing databases. One of these databases has suddenly grown in size from 6gb to 58gb within a matter of days.
Since it is a custom developed web app it uses a custom template and there is no view I can see to allow me to query all documents in the database and sort them by size.
I have run a fixup, updall, compact on the database and this immediately reduced the size from 58gb to 39gb but there is still 33gb of essentially unknown data I can’t get at or query.
Does anyone know where I can go from here to try and find out what and where all this data is in this database please and ideally also how its getting there!
Many thanks
Dan
Subject: Database suddenly grown from 6gb to 58gb
Have you checked the size of each view in log.nsf? May be it can give you some hints.
Subject: RE: Database suddenly grown from 6gb to 58gb
We’ve had two different situation where something silimar happened to us
- An old laptop was replicated with a database. The laptop had not been replicated for almost a year and it put back in it’s old content. Problem was that the deletion stub were gone after 90 days.
Prevent : make sure that the option “only replicate incoming documents saved or modified after” is accurate
- An old laptop was replicated with a database. The laptop had modified every document (a bad agent did this). And since it was an old replica, every document came into the database in conflicts.
Resolve : delete every conflict documents
I hope this helps you
Subject: RE: Database suddenly grown from 6gb to 58gb
Thank you. I have already removed conflict documents int he views I can get to but I don’t seem able to access hidden views by ctrl-shift clicking the database.
Subject: Database suddenly grown from 6gb to 58gb
select the db in the admin client then right click and choose Manage Views. A prompt will come up after a few minutes showing all of the view sizes. See if you have many large view indexes. Did anyone recently run updall -R on it?
Subject: RE: Database suddenly grown from 6gb to 58gb
Thank you, I have done this now and I can see that there is 43gb of attachments from mailing in, this seems like an awful lot. Even when I double click ont he database with ctrl-shift I can only see the standard views the developer has put in, not the hidden views so I can’t query the documents in these views directly. Is there any other way of doing this?