PME - RAM and CPU usage are high, but PME is not logging new data

Search FAQs

You are currently viewing the content available in Vietnam. If you are looking for information for another region, please select the correct country from the top-left dropdown in the page and 'Navigate to Browse FAQs' in the Support menu.

Issue

RAM and CPU usage are high, but PME is not logging new data

Product line
Power Monitoring Expert 9.0

Power Monitoring Expert 2020

Power Monitoring Expert 2021

Power Monitoring Expert 2022

Power Monitoring Expert 2023

Environment

Microsoft Windows 10

Cause
"ION Log Subsystem Router Service" runs the stored procedure “RebuildAlarmRelatedIndexes” to rebuild indexes on major ION_DATA tables.
For large databases, it may take longer and affect system performance.

Resolution
Update the stored procedure to do a REORGANIZE vs a REBUILD function on the indexes.
The attached SQL file will make the required changes in the "RebuildAlarmRelatedIndexes" stored procedure.