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:
|