Global Transaction ID

The gtrid column displays the global transaction ID for distributed transactions coordinated by SAP ASE.

Transaction branches that are part of the same distributed transaction share the same gtrid. You can use a specific gtrid with the sp_transactions gtrid keyword to determine the state of other transaction branches running on the current server. This is useful for system administrators who must determine whether a particular branch of a distributed transaction should be heuristically committed or rolled back.

Note: For transactions coordinated by an X/Open XA-compliant transaction manager, MSDTC, or SYB2PC, the gtrid column shows the full transaction name supplied by the external coordinator.