sysproxytxns table
The sysproxytxns table contains information about all of the current transactions that are running through each proxy distributor.
On the primary server, this table contains information about each of the proxy distributors in the high-availability cluster. On a secondary server, this table only contains information about the proxy distributors used to process updates to the secondary server.
The following
table provides information about the columns in the sysproxytxns table:
| Column | Type | Description |
|---|---|---|
| proxy_id | integer | ID of the proxy distributor. These IDs are unique within a high-availability cluster. |
| proxy_txn_id | integer | Number of the transaction. These numbers are unique to the proxy distributor. |
| reference_count | integer | Indicates the number of threads (for example, sqlexec, sync reply, recovery, and so on) that are using the information for this transaction. When the count becomes 0 this indicates the transaction processing is complete. (either successfully or unsuccessfully). |
| pending_ops | integer | On the primary server: the number of operations received from the secondary server that have not yet been processed. On the secondary server, the number of operations buffered on the secondary server that have not yet been sent to the primary server. |
| proxy_sid | integer | Proxy Session ID |