Calculate size requirements for RDB

Find and share HowTos to various installations / configurations!
2 posts • Page 1 of 1
emaddocks
Posts:83
Joined: Tue Sep 04, 2018 12:50 am

Calculate size requirements for RDB

Post by emaddocks »

Hi,

Does anyone know how many bytes are used for storing individual Digital and Analog event and alarm data in a historical RDB?

Ultimately we would like to do a rough size calculation by knowing how many IO points we have configured as archived and how often we expect the values to change.

For example:
  • If a Digital Point is 100 bytes per record
  • We have 10,000 Digital Points archived
  • We expect a state change once every minute on average
This would require = 100 * 10,000 * 1,440 = 1.44 GB / day

Cheers
Eric

leoknipp
Posts:2928
Joined: Tue Aug 24, 2010 7:28 pm

Re: Calculate size requirements for RDB

Post by leoknipp »

You can have a look at the following entry in the Knowledge Base
https://www.winccoa.com/knowledge-base/ ... d7b5470156

Best Regards
Leopold Knipp
Senior Support Specialist

2 posts • Page 1 of 1