Repeated Databse Lock alarm thrown @GEO SCADA!!!

[BGedco2022]

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?

[sbeadle]

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