Solved

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

Posted on 2014-12-16
6
187 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

If, like me, you have a lot of Dell servers in the estate you manage this article should save you a little time. When attempting to login to iDrac on any server I would be presented with two errors. The first reads "Do you want to run this applicati…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

695 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