How much memory does a single data log value consume within PME?
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'
3) This will produce a report that shows the memory usage per table within the database as shown below.
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.
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'
3) This will produce a report that shows the memory usage per table within the database as shown below.
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.
게시 대상: 슈나이더 일렉트릭 Korea
도움이 필요하신가요?
제품 선택기
애플리케이션에 적합한 제품과 액세서리를 빠르고 쉽게 찾을 수 있습니다.
견적 받기
영업 관련하여 온라인으로 문의하시면 전문가가 연락드립니다.
구매처
해당 지역의 가장 가까운 슈나이더 일렉트릭 대리점을 쉽게 찾을 수 있습니다.
지원 센터
한 곳에서 모든 요구 사항에 대한 지원 리소스를 찾아보십시오.