The TargetDBName.Shredded_TransTbl stores additional shredded data for all blocked transactions involved in a lock contention. This table joins with the related table Shredded_LockTbl. The exact name of the target table is specified by the call to the stored procedure LockLogShredder.SP_CreateTable.
Shredded_TransTbl field | Description |
---|---|
QueryID | Unique query ID for joining with Shredded_LockTbl or other DBQL tables |
TransactionOrder | Sequence order of the blocked transaction |
DatabaseName | The database containing the object on which the blocked request is waiting for a lock |
TableName | The table on which the blocked request is waiting for a lock |
RequestID_1 | Byte 1 of the ID of the blocked request |
RequestID_2 | Byte 2 of the ID of the blocked request |
unique_1 | Part 1 of the transaction ID of the blocked request |
unique_2 | Part 2 of the transaction ID of the blocked request |
PEVproc | PE vproc of the blocked request |
TransactionState | Transaction state of the blocked request Possible values include the following:
|
TransactionStartTime | Start time of the blocked transaction |
StepNum_1 | Part 1 of the step number of the blocked request |
StepNum_2 | Part 2 of the step number of the blocked request |
SessionID_1 | Part 1 of the Session ID of the blocked request |
SessionID_2 | Part 2 of the Session ID of the blocked request |
SessionID_Combined | Combined session ID of the blocked request, as recorded in SessionTbl |
LockStatus | Lock status of the blocked transaction Possible values include the following:
|
LockTypeRequested | Type of lock requested by the blocked request Possible values include the following:
|
LockObjectRequested | The type of object on which the blocked request needs a lock Possible values include the following:
|