sysproxysessions table
The sysproxysessions table contains information about each of the sessions that are using redirected-write functionality. This table is only valid on the secondary server.
The following table provides information about the columns
in the sysproxysessions table:
| Column | Type | Description |
|---|---|---|
| session_id | integer | ID of a user's session on the secondary server. |
| proxy_id | integer | ID of the proxy distributor on behalf of which the proxy agent thread (TID) is running |
| proxy_tid | integer | Transaction ID of the proxy agent thread running on the primary server. This ID is created by the proxy distributor to handle work from the secondary server session. |
| proxy_txn_id | integer | Number of the current transaction. These numbers are unique to the proxy distributor. |
| current_seq | integer | The sequence number of the current operation in the current transaction. |
| pending_ops | integer | The number of operations buffered on the secondary server that have not yet been sent to the primary server. |
| 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 reference_count equals 0, the transaction processing has completed (either successfully or unsuccessfully). |