Database growth calculations
Factory default measurement logging
A measurement record in the database uses approximately 75 bytes of disk space. Based on the factory default data logging configurations, we can calculate the database growth for data logged from different device types.
Example
| Device Type | Daily Growth Rate (kB) | Number of Devices | Total Daily Growth (MB) | Total Annual Growth (GB) |
|---|---|---|---|---|
| ION7650 | 780 | 10 | 7.62 | 2.72 |
| PM8000 | 950 | 20 | 19.00 | 6.94 |
| PM3200 | 85 | 70 | 5.81 | 2.07 |
| TOTAL | - | 100 | 32.43 MB | 11.84 GB |
NOTE: Use the Database Growth Calculator tool to estimate the database growth for your system. The tool is available through the Exchange Community.
Custom measurement logging
Custom measurement logging can be configured in the monitoring devices and, as software based logging, in PME. A measurement record in the database uses approximately 75 bytes of disk space.
The following shows the database growth estimate for logging of a single measurement every 15 minutes:
|
NOTE: Use the Database Growth Calculator tool to estimate the database growth for your system. The tool is available through the Exchange Community.
Power quality event logging
Power quality (PQ) events and waveform capture recording is event driven, which makes it impossible to accurately predict their impact on database growth. In our experience, power quality data accounts for approximately 10% - 20% of the total database size.
NOTE: Use the Database Growth Calculator tool to estimate the database growth for your system. The tool is available through the Exchange Community.