View Partition Locks with monLocks and monDeadLock

View locked partitions in the partitionid column of the monLocks and monDeadLock monitoring tables.

monLocks

Description Datatype Attribute Description
partitionid int Null Unique identifier for the partition.

monDeadLock

Description Datatype Attribute Description
partitionid int Null Unique identifier for the partition.

See Performance and Tuning Series: Monitoring Tables.