RID Lock Requests (RIDLockRequestsPerSec)
Displays the number of new rows ID (RID) locks and lock conversions that the lock manager requested per second. To calculate the value of this parameter, the LocksColl parameter uses the SQL Server Lock Requests/sec performance counter for the RID instance.
Default parameter attributes
Attribute | Default value |
|---|---|
BMC PATROL properties | |
Application class | |
Command type | PSL |
Platform | Microsoft Windows |
Icon style | Graph |
Unit | RID lock requests per second |
Border range | Undefined |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling (poll time) | Not applicable |
Active at installation | Yes |
Parameter type | Consumer |
Value set by | |
BMC ProactiveNet Performance Management properties | |
Monitor type | SQL Server Locks |
Key Performance Indicator | No |
Monitor for abnormalities | No |
Graph by default | No |
Availability | No |
Response time | No |
Normal distribution | Yes |
Statistical | Yes |