EcoStruxure Geo SCADA Expert Forum
Schneider Electric support forum about installation, configuration, integration and troubleshooting of EcoStruxure Geo SCADA Expert (ClearSCADA, ViewX, WebX).
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-08-07 11:50 PM . Last Modified: 2023-05-02 11:53 PM
Hello There,
GEO SCADA continuously pop ups Databse Lock alarm with high rate range from 87% to 99% almost every week !!
-> What could be the causes?
-> How can we prevent GEO SCADA servers from encountering database locks?
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-08-08 12:30 AM
First off, a periodic high database lock may be perfectly normal, so don't panic!
It's indicating the system has a busy period. If you expect this, then just alter the lock period. Right click the root group, select Configure. Click the Performance tab and edit the alarm levels. You might want to increase the averaging period.
Good, temporary, reasons for long high lock periods include the execution of reports which make complex/long queries, or at the other end, outstations set to report data all at the same time. You could stagger the execution to reduce load.
So, there may be things you can do to improve matters and ensure good performance to users. Look at the Logic (see in Queries - Logic Execution Status) to see if you have excessive runs/frequency, overruns. For further help see the Knowledge Base sections on performance.
Steve
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.