3.18 Database Transactions

The metrics in this category provide information about Adaptive Server transactions.

Collection Frequency - Every 12 hours

Table 3-22 Database Transactions Metrics

Metric Description

Connection State

Value indicating the connection state.

Transaction Failover State

Value indicating the transaction failover state.

Lock Owner ID

Lock owner ID.

Length of Transaction Name

Length of transaction name.

Transaction Server Process ID

Server process ID, or 0 if the process is detached.

Remote Server Name

Name of the remote server.

Transaction State

Value indicating the current state of the transaction.

Transaction Status

Status of the transaction.

Transaction Type

Value indicating the type of transaction.

Transaction Key

Unique identifier for a transaction.

Transaction Start Time

Start time of the transaction.

Coordination Method or Protocol

Value indicating the coordination method or protocol.

Starting database of the transaction

Starting database of the transaction

Transaction Name

Name of the transaction.