História stránky

A unique identifier of the object of type Database within the DODM model.

A unique identifier of the process within which the Database is located. In the case of DbManager instance processes, the same Database can be on several lines. 

The name of the process from which the information about the Database comes. In the case of DbManager instance processes, the same Database can be on several lines.

* Connects

The number of connections to the SQL database in individual states.

The total number of operations (database actions) performed on the Database object by the DbManager process (since the start or since the last statistics reset).

The total duration of operations ( database actions) performed on the Database object by the DbManager process (since the start or since the last statistics reset).

Duration of the longest operation performed on the Database object by the DbManager process (since the start or since the last statistics reset).

The name of the longest operation performed on the Database object by the DbManager process (since the start or since the last statistics reset).

Comment on the longest operation (information about the sequence of calls within the ESL script).

Identifier of connection within the Database object.

Unique name of the connection within the DbManager process.

A unique identifier of the object of Database type within the DODM model.

A unique identifier of the process within which the Database is located. In the case of DbManager instance processes, the same Database can be on several lines. 

The name of the process from which the information about the Database comes. In the case of DbManager instance processes, the same Database can be on several lines.

Information on whether the connection is currently performing some activity (Busy) or is idle (Idle)

Connection type:

• NonTransact - non-transactional connection (shared)
• Transact - transactional connection (exclusively assigned to the script by the DB_TRANS_OPEN action)
• Browse - a non-transactional connection reserved for the Browser display (if such a connection is enabled in the configuration of the Database object by the Reserved browser connections parameter.

Note: A transactional connection that has a Normal status is suspicious.
If it is inactive for a longer time (Idle), it is an uncommitted transaction that do nothing (and potentially blocks other connections). If it is active for a longer time (Busy), this is a long-running database action that should be analyzed and ideally optimized (to shorten its duration).

The number of handles within the connection. Handles are created by the actions DB_CONNECT, PG_CONNECT, SQL_CONNECT, the action DB_TRANS_OPEN, and in transactional mode by every database action until the DB_TRANS_COMMIT or DB_TRANS_ROLLBACK is called.

If the connection is in a Busy state, then the number of times the watchdog interval has elapsed. This is 60 seconds by default, it can be set with the start parameter /KD.

A unique identifier of the object of Database type within the DODM model.

A unique identifier of the process within which the Database is located. In the case of DbManager instance processes, the same Database can be on several lines. 

The name of the process from which the information about the Database comes. In the case of DbManager instance processes, the same Database can be on several lines.

The operation for which statistics are displayed. The operation is e.g. action in the script (e.g. DB(S)_READ) or , work with the browser (Browser Edit, Browser Control), automatic data refresh in the browser (Browser Autorefresh), or waiting for requests in service task queues (Queued time).

The total number of operations of a specific type performed on the Database object by the DbManager process (since the start or since the last statistics reset).

The total duration of operations of a specific type performed on the Database object by the DbManager process (since the start or since the last statistics reset).

Duration of the longest operation of a specific type performed on the Database object by the DbManager process (since the start or since the last statistics reset).

The name of the longest operation of a specific type performed on the Database object by the DbManager process (since the start or since the last statistics reset).

Comment on the longest operation (information about the sequence of calls within the ESL script).