{}

Our Brands

Welcome to the Schneider Electric Website

Welcome to our website.
How can we help you today?
PME - RAM and CPU usage are high, but PME is not logging new data

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.



Schneider Electric Nigeria

Attachment(s)
RebuildAlarmRelatedIndexes_modification.sql [808 Bytes]
PME - RAM and CPU usage are high, but PME is not logging new data

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.
 


 

Schneider Electric Nigeria

Attachment(s)
RebuildAlarmRelatedIndexes_modification.sql [808 Bytes]
Explore more
Range:
Explore more
Range:
Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Range:
Explore more
Range:
move-arrow-top
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.