# How large should I make the Onepoint database? (NETIQKB2188)

• 7702188
• 02-Feb-2007
• 08-Sep-2008

## Resolution

goal
How large should I make the Onepoint database?

fix
The size of the Onepoint database should be determined by the amount of data collected daily. The following formula can be used for estimating database capacity.

NOTE: Values for monitoring your environment may differ from the ones included below.

Known Information:

Each alert requires between 5 - 6 KB each
Each event requires between 500 bytes - 2 KB each
Each performance data item requires 135 bytes each

Required Information:

w=Number of days in a month
x= Number of alerts generated in a single day
y= Number of events generated in a single day
z= Number of perf data items collected in a single day
1 MB = 1,048,576 bytes

Solve the equation in terms of bytes:

[(x*6000)+(y*2048)+(z*135)]w
------------------------------------------- = Monthly MB Required
1,048,576

SAMPLE CALCULATION:

Number of days in the month (w) = 31
Number of alerts in a given day (x) = 100
Number of events in a given day (y) = 100,000
Number of perf data in a given day (z) = 100

For our formula we are assuming the highest values in size for alerts, events, and performance data to try and derive the highest estimate. This also assumes a linear consistent growth.

Formula and Solution:

[(100*6,000 bytes)+(100,000*2,048 bytes)+(100*135 bytes)]31
------------------------------------------------------------------------------------
1,048,576 bytes/MB

[(600,000 bytes)+(204,800,000 bytes)+(13,500 bytes)]31
------------------------------------------------------------------------------------
1,048,576 bytes/MB

[205,413,500 bytes]31
-------------------------------
1,048,576 bytes/MB

6,367,818,500 bytes
-------------------------------
1,048,576 bytes/MB

6,072.824954 MB rounded to nearest whole number is 6,073 MB. This equals 6.1 GB per month.