| Inst ID |
Instance ID; 0 = non-CE |
| SPID |
Session process ID; 0 = Detached process |
| Elapsed Time |
Elapsed time |
| Transaction Name |
Transaction name, or XA transaction ID (XID) |
| Type |
Transaction type (Local, External, Dtx_State, Remote) |
| Start Time |
Start time of transaction |
| Initial Database |
Starting database name |
| Server Name |
Remote server name, if applicable |
| Login |
Login name of process |
| LockID |
Lock owner ID |
| Application |
Application name of process |
| Client IP Address |
Client host IP address of process |
| Client OS PID |
Client OS PID of process |
| XA Global Transaction ID |
Binary version of the global transaction ID portion of XID |
| XA Branch Qualifier |
Binary version of the branch qualifier portion of XID |
| State |
Current state of the transaction:
- Begun
- Done Command
- Done
- Prepared
- In Command
- In Abort Cmd
- Committed
- In Post Commit
- In Abort Tran
- In Abort Savept
- Begun-Detached
- Done Cmd-Detached
- Done-Detached
- Prepared-Detached
- Pseudo Prepared
- Heur Committed
- Heur Rolledback
|
| Connection |
Connection state (Attached, Detached) |
| Failover |
Transaction failover state (Resident Tx, Failed-over Tx, Tx by Failover-Conn) |
| Coordinator |
Coordination method (None, Syb2PC, ASTC, XA, DTC) |
| Transaction Key |
Transaction key |