The metrics in this category provide information about a list of all locks that are being held, and those that have been requested, by any process, for every object.
Collection frequency - Every 45 minutes
Table 3-28 Locks Information Metrics
Metric | Description | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
Lock State |
Whether the lock has been granted [Granted, Requested]. The upload frequency is after every sample and the operator is >. Alert text is - The lock state is %LockState%. For this metric, you can set different warning and critical threshold values for each unique combination of "SPID", "KPID", "DBID", "Lock ID", and "Object ID" objects. If warning or critical threshold values are currently set for any unique combination of "SPID", "KPID", "DBID", "Lock ID", and "Object ID" objects, those thresholds can be viewed on the Metric Detail page for this metric. To specify or change warning or critical threshold values for each unique combination of "SPID", "KPID", "DBID", "Lock ID", and "Object ID" objects, use the Edit Thresholds page. |
Not Defined |
Not Defined |
The lock state is %LockState%. |
Table 3-29 Locks Information Metrics
Metric | Description |
---|---|
Lock context |
Lock context (bit field). These values are the same as the values for the context column in syslocks. |
Lock Level |
The type of object for which the lock was requested (‘PAGE', ‘ROW', and so on). |
Lock Type |
Type of lock [‘exclusive table', ‘shared page', and so on |
Locked page number |
Page that is locked when LockLevel = ‘PAGE'. |
Parent SPID |
Parent process ID. |
Locked row number |
Locked row numberRow that is locked when LockLevel = ‘ROW'. |
Lock wait time |
The time (in seconds) that the lock request has not been granted. |
SPID |
Session process identifier. |
KPID |
Kernel process identifier. |
DBID |
Database identifier. |
Lock ID |
Lock identifier. |
Object ID |
Object identifier. |