How much memory does a single data log value consume within PME?

Hvordan kan vi hjælpe dig i dag?

Issue
How much memory does a single data log value consume within PME?

Product Line
Power Monitoring Expert (PME)
StruxureWare Power Monitoring (SPM)
ION Enterprise (ION-E)

Environment
SQL server databases

Resolution
This value can vary based on the installed version of PME for the system, but this can be checked through SQL Management Studio.

** Warning: Only those familiar with SQL server and PME should be working with SQL Management Studio. Making direct modifications to the PME databases can leave a system inoperable and require restoration from backups. **

1) Log in to SQL Management Studio
2) Expand the databases folder, right-click ION_Data, select Reports < Standard Reports < 'Disc Usage by Top Tables'

SSMS Reports Table

3) This will produce a report that shows the memory usage per table within the database as shown below.

SSMS Reports Table 2

4) Divide the number of records by the Data (KB) column for the DataLog2 table. This will give an approximate value of the memory usage for a single-row entry.
2,265,592 / 95,808 = 23.6472110888, so each row entry within the DataLog2 table consumes approximately 23.67 kilobytes of hard drive space.
This example was taken from a PME 8.1 test system.