The QryLockLogXML[V] view of DBQLXMLLOCKTbl is populated if the WITH LOCK option is requested in addition to the default information row. Each row stores a subset of the XML document recording lock delays.
|CollectTimeStamp||Date and time when the lock contention is recorded. This is different from the time when the contention first occurs. A field inside XMLTextInfo represents the start time of the contention.
The lock contention may be recorded minutes after it begins, depending on when the information is flushed to the AMP. The default AMP flush rate is 10 minutes. To find when the lock was finally granted, add the lock delay duration to the start time.
For more information on CollectTimeStamp, see Comparing CollectTimeStamp Value Between Tables.
|ProcID||Unique processor ID of the AMP vproc that processed the request.|
|QueryID||Internally generated identifier of the query.|
|XMLTextInfo||Lock plan represented as an XML document.|