Locks Information

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 4-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 4-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.