Search FAQs
Tracking DB Lock Usage in Geo SCADA
DB Lock Usage could be tracked and historized. This is helpful to visualize the utilization of database locks across the system over time.
Several OPC properties related to DB Lock Usage are located here:
The LUSPercLockAcquired OPC property is the one we are interested in. Please create an Analog Calculation point and configure it to the following settings:
![Calculation Point Settings Calculation Point Settings](https://ckm-content.se.com/ckmContent/servlet/servlet.ImageServer?id=0158V00000CVW7ZQAX&oid=00DA0000000abSmMAI)
![Calculation Point Settings Calculation Point Settings](https://ckm-content.se.com/ckmContent/servlet/servlet.ImageServer?id=0158V00000CVW7aQAH&oid=00DA0000000abSmMAI)
Make sure the Historic aggregate is enabled on the calculation point.
The DB Lock Usage can now be tracked:
![Trending DB Lock Usage Trending DB Lock Usage](https://ckm-content.se.com/ckmContent/servlet/servlet.ImageServer?id=0158V00000CVW7bQAH&oid=00DA0000000abSmMAI)
![Viewing DB Lock Usage in Historic List Viewing DB Lock Usage in Historic List](https://ckm-content.se.com/ckmContent/servlet/servlet.ImageServer?id=0158V00000CVW7cQAH&oid=00DA0000000abSmMAI)
Several OPC properties related to DB Lock Usage are located here:
- PerformanceStats.LUSPercLockAcquired
- PerformanceStats.LUSPercLockAcquiredTime
- PerformanceStats.LUSAlarmed
The LUSPercLockAcquired OPC property is the one we are interested in. Please create an Analog Calculation point and configure it to the following settings:
Make sure the Historic aggregate is enabled on the calculation point.
The DB Lock Usage can now be tracked:
Released for:Schneider Electric Singapore
Explore more
Product:
Explore more
Product: