DbManager Diagnostic Pack provides an overview of the work of the DbManager process and information about objects of type Database, Table , and about currently existing connections to SQL databases. It is accessible from D2000 CNF from menu Objects -> DbManager Diagnostic Pack or from D2000 GrEditor, from menu Configuration D2000 -> DbManager Diagnostic Pack.

Additionally, it is accessible fromD2000 CNF for Database and Table objects from the Extended actions context menu. In this case, it opens with a filter - it only contains information about the selected database (in the case of an object of the Table type about the parent Database).

After pressing the right mouse button, all tabs offer a menu with the option Copy, which copies the displayed list to the clipboard, and the option Copy '<column name>', which copies a specific item to the clipboard. Some of the tabs also offer additional actions.

In individual tabs, columns can be filtered, sorted (by clicking on the header), and both the order of columns and their widths can be changed (by Drag & Drop in case of columns order). The settings are stored in the Windows Registry database. The DbManager Diagnostic Pack window can be opened multiple times (e.g. for different databases from the context menu).


A view of DbManager processes (*.DBM) is provided by the Processes tab.

Meaning of the columns:

ID (HOBJ)

Unique identifier of the Process type object within the DODM model.

NameUnique name of the Process type object within the DODM model.
ActiveIn the case of instance DBM processes (e.g. [1]_SELF. DBM) information on whether the instance is active).
IPThe identifier of the computer on which the process is running.
AllocatedMermoryThe amount of memory used by the given process.


The context menu offers other extended actions:

  • Read statistics - all databases: statistics about Database objects from the selected DBM process are displayed on the Database Statistics tab.
  • Read statistics - all tables: statistics about Table objects from the selected DBM process are loaded on the Table Statistics tab.
  • Reset statistics - all databases: statistics on objects of type Database from the selected DBM process will be cleared (irreversibly).
  • Reset statistics - all tables: statistics on Table objects from the selected DBM process will be cleared (irreversibly).


A view of Database type objects is provided by the Databases tab:

For each Database, its parameters and summary statistics are available:

ID (HOBJ)

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

NameA unique name of the object of type Database.
ID process

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. 

Process

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.

Operations

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).

Total Duration

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).

Max Duration

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

Max Operation

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

Max Comment

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

The context menu offers other extended actions:

  • Read <Database name> databases statistics: statistics about the selected object of Database type are read on the Database Statistics tab.
  • Read <Database name> tables statistics: statistics about the selected object of Table type are read on the Table Statistics tab.
  • Reset <Database name> databases statistics: statistics about the selected object of Database type will be cleared (irreversibly).
  • Reset <Database name> tables statistics: statistics about the selected object of Table type will be cleared (irreversibly).


A view of database connections is provided by the Connects tab.

For each database connection, its parameters and statistics are available:

ID

Identifier of connection within the Database object.

Name

Unique name of the connection within the DbManager process.

ID Database

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

DatabaseA unique name of the object of Database type.
ID Process

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. 

Process

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.

StateState of the connection.
Busy/Idle

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

Busy/Idle TimeDuration of Busy/Idle state.
Busy DetailsBusy status details - details about the activity being performed.
Connect Type

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).

Handles

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.

WD Expired

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 view of the handles is provided by the Handles tab.

Handles are internal structures of the DbManager process. They are created by DB_CONNECT, PG_CONNECT, SQL_CONNECT, DB_TRANS_OPEN, and in transactional mode by every other action until the call DB_TRANS_COMMIT or DB_TRANS_ROLLBACK is called. Descriptors are bound to a specific database connection.

For each handle, its parameters are available:

ID

Identifier of the handle.

ID Connect

Identifier of the connection within which the descriptor was created.

Connect

Unique name of the connection within the DbManager process.

ID Database

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

DatabaseA unique name of the object of Database type.
ID Process

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. 

Process

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.

Handle Type

Descriptor type:

  • Table - table handle can be opened from process  D2000 HI through the list of database tables, in the Browser, or from script by using the actions DB_CONNECT, PG_CONNECT, SQL_CONNECT, SQL_PREPARE as well as for a short period of time (during an action) by calling DBS_* actions.
  • Transaction - transaction handle can be opened by the action DB_TRANS_OPEN.
  • ConnectString - connection handle is opened by the SQL_CONNECT, if the first parameter of the action is connectString.
  • Database - database handle is opened by the action SQL_CONNECT, if the first parameter of the action (dbObjIdent) is of Database type.
Table

The name of the Table or Database object (if Descriptor Type=Transaction) to which the descriptor is bound

Comment

Comment on the descriptor creation (information about the sequence of calls within the ESL script).


A view of group statistics of operations in databases is provided by the Database Statistics tab.

For each object of the Database type, its group statistics are available (grouped according to the types of database actions):

ID Database

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

DatabaseA unique name of the object of Database type.
ID Process

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. 

Process

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.

Operation

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).

Count

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).

Total Duration

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).

Max Duration

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).

Max Operation

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).

Max Comment

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


A view of table statistics is provided by the Table Statistics tab.

For each object of the Table type, its group statistics are available (grouped according to the types of database actions):

ID TableA unique identifier of the object of Table type within the DODM model.
TableA unique name of the object of Table type.
ID Database

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

DatabaseA unique name of the object of Database type.
ID Process

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. 

Process

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.

Operation

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).

Count

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

Total Duration

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

Max Duration

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

Max Comment

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


Related pages:

DbManager - Tuning and Debugging

Napíšte komentár