Issue
A site is required to store Extended Trend Log historical data for an extended period of time, in order to make sure the system has enough capacity for all the data it is necessary to calculate the storage needed ahead of time
Product Line
EcoStruxure Building Operation
Environment
- Building Operation Enterprise Server
- Building Operation Workstation
Cause
Understanding the storage requirements for long term trend storage
Resolution
Formula to calculate the storage capacity needed for Extended Trend Log data.
Storage in bytes (S) = Number Of Records (N) x 70 bytes.
EXAMPLE:
Consider a trend log of 1000 records with a 10-minute interval, if the requirement is to keep 5 years of data, how much storage capacity will be required?
- The number of records would (N) be... 6 records per hour times 24 hours per day times 365 days per year*** times 5 years
(*** leap years must be taken into account) - N = 6 X 24 X 365 X 5 = 262800 bytes
This equates to:
- S = N X 70
- S = 262800 X 70
- S = 18396000 bytes or approximately 18 megabytes
Note - The calculations above are for the native SQLite database used by EBO. There are two alternatives to using the ES database for long-term trend storage.
- Report Server - See the WebReports Database Usage Calculator Knowledge base article for storage calculations
- External Log Storage is possible from EBO v3.0 using TimescaleDB database - The EBO External Log Storage Installer tool from the community provides a databases size estimator located under the Tools menu item
