Solved

How many GB is a good number to keep these databases?

Posted on 2014-12-16
6
179 Views
Last Modified: 2014-12-17
Hi Experts,
I have 7 big aplications on my Domino Server that has over 50GB. I'll try to use historical bases in order to shrink those aplications. I wonder how many GB I need to purge from those databases to keep my server healthy.

My Domino Server run MS WIN server 2008 R2 over VMWare.
Domino version is 8.5.2FP4.
1 TB of disk divided in 2 partitions : C for System (100GB), D for Domino\Data (900GB).

Thanks in advance
0
Comment
Question by:AlexanderPaludetto
  • 3
  • 2
6 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 40504310
IMHO the server is healthy, and smaller databases do not necessarily run lots faster or better. You might put your focus elsewhere, for 50 Gb isn't that much, considering there are 1 Tb disks for under $100...

If you want to invest in a better server, have a look at:
- a proper backup utility
- DAOS
- a backup Domino server
- clustering
- upgrading to R9
0
 
LVL 1

Expert Comment

by:Fredrik Norling
ID: 40504321
Hi,

I would check if the applications has lot's of attachments because then you could enable Daos on the server and gain back the speed of the database.

a Domino database can't within it self grow larger than 64GB

So if the databases are large you should consider to archive old stuff or group it in another way.
0
 

Author Comment

by:AlexanderPaludetto
ID: 40504822
Hi Fredrik,

That's the idea.
The developers team at my company will create an agent to cut documents from one base to another. We don't use DAOS on aplication servers. So before start using DAOS on this server I was wondering what is a good size to keep those aplications.
0
Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

 
LVL 1

Accepted Solution

by:
Fredrik Norling earned 500 total points
ID: 40504834
That's depending on how the application is built and how many documents you have in the database.
but 10 - 20GB is usually OK.

One need to look at view indexes and the sizes of them.

Number of documents in the most commonly used views.

is Reader & Authornames used in the database.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 40504859
In many cases you don't need agents to do archiving! Notes has standard archiving capabilities, server-size or client-side. Documents can be moved automatically from the man db to the archive db. What's more: they retain their Universal ID when move to the archive. Of course, the structure of the application has to allow archiving based on modification date alone, otherwise you'll have to develop an agent that tags documents to be archived: simply set the field ExpireDate to the date the document will expire, and archiving will move it to the archive db.

See also the Admin Help database, about the Compact task.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 40505160
Thank you for your interest in my comments... :-(
0

Featured Post

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question