Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| transaction_id | uniqueidentifier | 16 | null |
|
|
|||
| database_id | int | 4 | null |
|
|
|||
| transaction_state | int | 4 | null |
|
|
|||
| resource_manager_id | uniqueidentifier | 16 | null |
|
|
|||
| resource_manager_server | nvarchar | 522 | √ | null |
|
|
||
| resource_manager_database | nvarchar | 258 | √ | null |
|
|
||
| resource_manager_dbid | int | 4 | null |
|
|
|||
| resource_manager_state | int | 4 | null |
|
|
|||
| resource_prepare_lsn | nvarchar | 48 | √ | null |
|
|
||
| resource_phase_1_time | bigint | 8 | null |
|
|
|||
| resource_phase_2_time | bigint | 8 | null |
|
|
|||
| transaction_phase_1_time | bigint | 8 | null |
|
|
|||
| transaction_phase_2_time | bigint | 8 | null |
|
|
|||
| transaction_total_time | bigint | 8 | null |
|
|
|||
| transaction_diag_status | int | 4 | null |
|
|
|||
| resource_manager_diag_status | int | 4 | null |
|
|
|||
| max_csn | bigint | 8 | null |
|
|
Relationships
Close relationships within degrees of separation
