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:
Make sure the Historic aggregate is enabled on the calculation point.
The DB Lock Usage can now be tracked:
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: