Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2014-12-16
6
Medium Priority
?
198 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 1

Accepted Solution

by:
Fredrik Norling earned 2000 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Convert websphere application server default chained Certificates from 1024 to 2048 keysize or higher size and also you can change signatureAlgorithm . Please make sure Websphere Application Server fixpack 7.0.0.23 or Above. The following steps a…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
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.…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

618 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